Try escaping the $catid like: WHERE cat_id='$catid' Aaron -----Original Message----- From: Alawi shekh albaity [mailto:alawi2002@php4web.com] Sent: March 1, 2003 1:04 AM To: php-db@lists.php.net Subject: 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
