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:
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
The Cryptocomm Group
My GPG Key:

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to