Page 1 of 1

sql problems

Posted: Fri Apr 18, 2003 10:46 pm
by nincha
$category_id=1;
$sql = "DELETE * FROM `shop_category` WHERE `id` = $category_id";
mysql_query($sql);

can some one tell me the syntax to fix this. thnx

Posted: Sat Apr 19, 2003 5:27 am
by twigletmac
Have you checked the MySQL manual (the error is pretty simple to fix):
http://www.mysql.com/doc/en/DELETE.html

Mac