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 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: 
    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 ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc 

Reply via email to