Re: What wrong in this SQL
| From: | Adam Voigt | Date: | Thu, 27 Feb 2003 19:09:43 +0000 |
| Subject: | Re: What wrong in this SQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25969@lists.php.net to get a copy of this message | ||
A. Are you using a database that supports multitable deletes?
B. Try joining, like:
DELETE FROM cats a, articles b WHERE a.cat_id = $catid AND b.cat_id =
$catid;
Let me know.
On Sat, 2003-03-01 at 01:03, Alawi shekh albaity wrote:
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
--
Adam Voigt (adam@cryptocomm.com)
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc