the problem is that mysql do not support multi table because it works when I am remove
the table
Thanks to all for help
- Original Message -
From: Adam Voigt
To: Alawi shekh albaity
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 11:09 AM
Subject: Re: [PHP-DB] What
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 :
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
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:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 11:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Wh