Deleting Multiple with foreach

[johnskywalker99]

Hello
I'm trying to delete multiple entries from a mysql table using the following script:

variables are passed using:
<input type="checkbox" name="s1tab" value="10">

if ($delete) {
$db = mysql_connect("$sql_server", "$user_name", "$user_pass");
mysql_select_db("$db_name",$db);
foreach($s1tab as $value) {
$query = 'DELETE FROM $db_table_tabular WHERE s1tab=$value';
}

Needless to say but I'm asking for help because all I get is this on submit:

Warning: Invalid argument supplied for foreach() in ..../process.php on line 25

If anyone can help I will love you unconditionally forever
😃

Cheers JOhn

[johnskywalker99]

I am looking at other posts on this subject to see if there is any resolution also....

[lurius]

Name should be :
name="s1tab[]"

and then you can use
foreach ($POST['s1tab'] as $value)
OR
foreach ($GET['s1tab'] as $value)

-Lurius

[tomhath]

You might also want to run the query with mysql_query() inside the foreach loop 😉

[johnskywalker99]

bugger its amazing what you miss when you don't sleep ...cheers!