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:alawi2002@php4web.com] Sent: Friday, February 28, 2003 11:04 PM To: php-db@lists.php.net Subject: What wrong in this SQL 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
