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 
  Sent: Thursday, February 27, 2003 11:09 AM
  Subject: Re: [PHP-DB] What wrong in this SQL

  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 ( 
    To unsubscribe, visit: 

The Cryptocomm Group
My GPG Key: 

Reply via email to