wheres the error?

[Anon]

This query statement is causing me a syntax error, "You have an error in your SQL syntax near 'where category_id = ' at line 1"

else if (isset($update))
{

$query = "update category set category_type = '$category_type' where category_id = $category_id";

mysql_query($query) or 
die (mysql_error());

}

The database, tables, and columns exist and can be connected to. Any suggestions will be appreciated. Thanks abdul

[Anon]

$query = "update category set category_type = '$category_type' where category_id = '$category_id'";

note the single quotes around $category_id

[Anon]

Thanx Devin, it was just I have exactly the same syntax in another script and it works without the quotes! but hey its working now so thanx very much