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: Of course you can use a while loop to output the form. Then in your PHP code that processes this form, you need to run a query for every one of the data you

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 = '1

[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 taki