RE: [PHP-DB] What wrong in this SQL
| From: | Aaron Wolski | Date: | Thu, 27 Feb 2003 19:08:21 +0000 |
| Subject: | RE: [PHP-DB] What wrong in this SQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25968@lists.php.net to get a copy of this message | ||
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: [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