Try escaping the $catid like: WHERE cat_id='$catid'
Aaron -----Original Message----- From: Alawi shekh albaity [mailto:[EMAIL PROTECTED] Sent: March 1, 2003 1:04 AM 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