[RESOLVED] checkbox problem

[doofystyle]

I have multiple checkboxes

$result7 = $db->sql_query("select id from ".$prefix."_huntlist ORDER BY id");
while(list($id) = $db->sql_fetchrow($result7)) {

echo "$id <input type=\"checkbox\" name=\"cid[]\" value=\"$id\"></td></tr>";
}

I do see the checkboxes but when I check more than 1 box only the last one I check gets put into my database.

foreach($POST["cid"] AS $key => $value){
sql_query("insert into ".$prefix."huntteampts values ('$cid')", $dbi);
}

what am I doing wrong.

[rincewind456]

Well if your calling the parts of $POST['cid'], $key and $value then to get the value it would need to be like this

foreach($_POST["cid"] AS $key => $value){
sql_query("insert into ".$prefix."_huntteampts values ('$value')", $dbi);
}

[nemonoman]

Just a guess that you also what to change "prefix"

foreach($POST["cid"] AS $key => $value){
sql_query("insert into ".$key."huntteampts values ('$value')", $dbi);
}

[doofystyle]

I have changed the code to this:

foreach($POST["cid"] AS $key => $value){
sql_query("insert into ".$prefix."huntteampts values ('$value')", $dbi);
}

but It still does not pass it to the db. I have to keep "prefix" it is just calling the correct table in the db.

[nemonoman]

Checkbox info is ONLY submitted if the checkbox has been checked: