checkbox

[hidjra]

hi guys,

can anyone help me with this, it has nothing to do with vbulletin.

i want to write/pull some info to/from the database, and show the values in checkboxes, for example;

when a user signs up, he/she checks his interests in a form with checkboxes, this form puts the values into a database table, seperated with a space. And afterwards the user should have the possibility to change this info.

How do i make a form that puts multiple values in one table, seperated with a space?
And afterwards; how do i make a form that pulls the info from the database, en checks the checkbox if values are found in the table?

does this make any sense?? :cross-eyed:

Hidjra

[hidjra]

i tried this, but this only works when a user checks just one of the checkboxes :knockedout:




$haalartiest = mysql_query("select artiestid,naam,synoniem,land,genre from club_artiest WHERE artiestid ='$artiestid'");
$array = $DB_site->fetch_array($haalartiest);


if ($array[genre] == "0") {
$genre0 = "checked";
} elseif ($array[genre] == "1") {
$genre1 = "checked";
} elseif ($array[genre] == "2") {
$genre2 = "checked";
} elseif ($array[genre] == "3") {
$genre3 = "checked";
} elseif ($array[genre] == "4") {
$genre4 = "checked";
} elseif ($array[genre] == "5") {
$genre5 = "checked";
} elseif ($array[genre] == "6") {
$genre6 = "checked";
} elseif ($array[genre] == "7") {
$genre7 = "checked";
} elseif ($array[genre] == "8") {
$genre8 = "checked";
}



<input type=\"checkbox\" name=\"genre\" value=\"1\" $genre1>
<input type=\"checkbox\" name=\"genre\" value=\"2\" $genre2>
<input type=\"checkbox\" name=\"genre\" value=\"3\" $genre3>
<input type=\"checkbox\" name=\"genre\" value=\"4\" $genre4>
<input type=\"checkbox\" name=\"genre\" value=\"5\" $genre5>
<input type=\"checkbox\" name=\"genre\" value=\"6\" $genre6>
<input type=\"checkbox\" name=\"genre\" value=\"7\" $genre7>
<input type=\"checkbox\" name=\"genre\" value=\"8\" $genre8>

so what's wrong with this picture

hidjra

[Sparkz]

The checkboxes need to have unique names, for starters...

[hidjra]

ok, i gave the checkboxes a unique name, and i succeeded in writing the value to the table, seperated with a space


<input type="checkbox\" name=\"genre[]\" value=\"1\" $genre1>
<input type=\"checkbox\" name=\"genre[]\" value=\"2\" $genre2>
<input type=\"checkbox\" name=\"genre[]\" value=\"3\" $genre3>
<input type=\"checkbox\" name=\"genre[]\" value=\"4\" $genre4>
<input type=\"checkbox\" name=\"genre[]\" value=\"5\" $genre5>
<input type=\"checkbox\" name=\"genre[]\" value=\"6\" $genre6>
<input type=\"checkbox\" name=\"genre[]\" value=\"7\" $genre7>
<input type=\"checkbox\" name=\"genre[]\" value=\"8\" $genre8>

$genres = implode($genre, " ");
mysql_query("insert into club_artiest (naam, synoniem, land, genre) values ('$naam', '$synoniem', '$land' , '$genres')");

but what do i have to change in here to display the checkboxes as checked when editing an entry ?

if ($array[genre] == "0") {
$genre0 = "checked";
} elseif ($array[genre] == "1") {
$genre1 = "checked";
} elseif ($array[genre] == "2") {
$genre2 = "checked";
} elseif ($array[genre] == "3") {
$genre3 = "checked";
} elseif ($array[genre] == "4") {
$genre4 = "checked";
} elseif ($array[genre] == "5") {
$genre5 = "checked";
} elseif ($array[genre] == "6") {
$genre6 = "checked";
} elseif ($array[genre] == "7") {
$genre7 = "checked";
} elseif ($array[genre] == "8") {
$genre8 = "checked";
}

[hidjra]

nobody?? hello guys :speechless: help needed :D

Hidjra