I don't believe you can delete from two tables simultaneously in this fashion, it's probably the ,articles that's the error.
<>< Ryan -----Original Message----- From: Alawi shekh albaity [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 11:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] What wrong in this SQL What wrong with this code in sql : $SQLSTATEMENT["DeleteCategory"] = " DELETE FROM cats, articles WHERE cat_id = $catid "; Error no: 1064 Details : You have an error in your SQL syntax near 'WHERE cat_id = 1 ' at line 4 -- 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
