Try putting the variable into single quotes mysql_db_query("phpads", "DELETE FROM adviews WHERE bannerID='$banresult[bannerID]'"); That should resolve the problem. Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
- [PHP-DB] Deleting specific records from MySQL tables Matthew Tyler