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