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'");
I assume that this never deletes any records, since no record can have an id column whose value is 8 and 18 at the same time? :--) Don't you mean "OR"? > > >i've tried various things such as taking away the single quotes, replacing >AND with a comma, etc. >after i figure out how to delete multiple records, i need to figure out how >to go about carrying data from checkboxes and finding a query to delete the >records that were checked on the previous page: > >ex. ><input type=checkbox name=id value=1> ><input type=checkbox name=id value=2> ><input type=checkbox name=id value=3> >etc. > > >any help would be appreciated. > >thanks very much, > > >Matt > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php