ok, i gave the checkboxes a unique name, and i succeeded in writing the value to the table, seperated with a space
PHP Code:
<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>
PHP Code:
$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 ?
PHP Code:
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";
}