RE: [PHP-DB] What wrong in this SQL
| From: | USA) | Date: | Thu, 27 Feb 2003 19:07:31 +0000 |
| Subject: | RE: [PHP-DB] What wrong in this SQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25967@lists.php.net to get a copy of this message | ||
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:alawi2002@php4web.com]
Sent: Friday, February 28, 2003 11:04 PM
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