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

Reply via email to