[PHP-DB] delete multiple records with one query

2002-07-01 Thread Matt Nigh
hi, i'm trying to delete multiple records at once from a mysql db and can't seem to figure out how to do so. here's the code i've been trying to troubleshoot with: $result_insert = mysql_query(delete from $mysql_table where id = '8' AND where id = '18'); i've tried various things such as

Re: [PHP-DB] delete multiple records with one query

2002-07-01 Thread Paul DuBois
At 22:37 -0400 7/1/02, Matt Nigh wrote: hi, i'm trying to delete multiple records at once from a mysql db and can't seem to figure out how to do so. here's the code i've been trying to troubleshoot with: $result_insert = mysql_query(delete from $mysql_table where id = '8' AND where id = '18');

Re: [PHP-DB] delete multiple records with one query

2002-07-01 Thread Tony
If you want to delete multiple items, you need to use array name condition in checkbox. Here's an example: form action = delete.php method = post input type = checkbox name = name_array[] value = value1 input type = checkbox name = name_array[] value = value2 !-- more and