foreach - Insert multiple check box values into multiple rows in one table? -

i have multiple check box same input name

<input type="checkbox" name="pop[]" value="pop1">pop1<br> <input type="checkbox" name="pop[]" value="pop2">pop2<br> <input type="checkbox" name="pop[]" value="pop3">pop3<br> <input type="checkbox" name="pop[]" value="pop4">pop4 <br> <input type="checkbox" name="pop[]" value="pop5">pop5<br> <input type="checkbox" name="pop[]" value="pop6">pop6 <br> <input type="checkbox" name="pop[]" value="pop7">pop7<br> <input type="checkbox" name="pop[]" value="pop8">pop8 <br> 

the database table contains 2 columns (id , popname).

i need every pop checked inserted database in separate row same id php:

$pop = implode(',', $_post['pop']); mysql_query("insert pops (id, popname) values (last_insert_id(), '$pop')"); 

but not working. tried stick answer make explode use each not working. foreach code:

$pop = implode(',', $_post['pop']); $pops = explode(',', $pop); foreach ($pops $pop ) {     mysql_query("insert pops (id, popname) values (last_insert_id(), '$pop')"); } 

am missing something!

it's solved.

problem $pop defined twice 1 var 1 in foreach

so after rename first var every thing ok

$popimp = implode(',', $_post['pop']); $pops = explode(',', $pop); foreach ($pops $pop ) { mysql_query("insert pops (id, popname) values (last_insert_id(), '$pop')"); }