sql problems

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nincha
Forum Contributor
Posts: 191
Joined: Fri Mar 28, 2003 12:30 pm
Location: CA, USA

sql problems

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Have you checked the MySQL manual (the error is pretty simple to fix):
http://www.mysql.com/doc/en/DELETE.html

Mac
Post Reply