Multiple checkboxes ? checked or not

[Anon]

Hi all,

I'm displaying a list of checkboxes where people can select the keywords that go with the image they upload... I save them in the DB (Mysql). so far so good.
But how can i display the list of checkboxes again [TO EDIT] with the one that where selected before "checked"

$sql = "SELECT * FROM download_keywords";
$sql_result = mysql_query($sql);
while ($row = mysql_fetch_array($sql_result)) {
$keyw_id = $row["id"];
$keyw_naam = $row["naam"];
echo "<input type=\"checkbox\" name=\"keyw_id[]\" value=\"$keyw_id\">$keyw_naam<br>\n";
}

//---------------------//

$count=count($keyw_id);

for ($i=0; $i<$count; $i++) {
$sql = "INSERT INTO download_keyw_img (image_id, keyword_id) VALUES ('$img_id', '$keyw_id[$i]')";
$result = mysql_query($sql);
}

DB:

CREATE TABLE download_keyw_img (
image_id int(11) NOT NULL,
keyword_id int(11) NOT NULL,
PRIMARY KEY (image_id, keyword_id)
);

CREATE TABLE download_keywords (
id int(11) NOT NULL auto_increment,
naam varchar(128) NOT NULL,
PRIMARY KEY (id)
);

[Anon]

a simple example:

<?
if ($submit) {
if (in_array("Donkey",$looking_for)){

$checkbox01 = "checked";
}
if (in_array("Bong", $looking_for))
{
$checkbox02 = "checked";
}
}
?>

<form action="<? echo ($PHP_SELF); ?>" method="post">
<input type="checkbox" name="looking_for[]" value="Donkey" <? echo ($checkbox01); ?>>Donkey<br>
<input type="checkbox" name="looking_for[]" value="Bong" <? echo ($checkbox02); ?>>Bong<br>
<input type="submit" name="submit" value="Submit">
</form>

i bet you can use this code for your purpose too..

/Stefan