Problem with update query.

[szms]

The following query is not updating the database. but if works perfectly in mysql. Any sugeestion???

$result8 = mysql_query("update NonDummyFunction set Count = Count - 1 where Function_ID = 'Component_ID'");

[tekky]

Originally posted by szms
The following query is not updating the database. but if works perfectly in mysql. Any sugeestion???

$result8 = mysql_query("update NonDummyFunction set Count = Count - 1 where Function_ID = 'Component_ID'");

yah try trouble shooting....

$result8 = mysql_query("update NonDummyFunction set Count = Count - 1 where Function_ID = 'Component_ID'" or die("error - ".mysql_error()); 

[szms]

I tried the following code but didn't get any error and at the same time it's not updating the Count in the database.

$result8 = mysql_query("update NonDummyFunction set Count = Count - 1 where Function_ID = 'Component_ID'");

if (!$result8)
{
print "Query Failed: " .mysql_error();
}

[tekky]

try the line I posted.... I didnt type it for my health... maybe it will display the error? obviously you have an error if nothing is happening....

[szms]

Got the following error:

Parse error: parse error in /usr/public_html/test.php on line 135

By the way line 135 is for the update command where I use your code.

Something wrong with

Count = Count - 1

Take a look!!1

[superwormy]

Parse error is not an SQL problem, fix teh parse error in your PHP code.

$result8 = mysql_query("update NonDummyFunction set Count = Count - 1 where Function_ID = 'Component_ID'") or die (mysql_error());

Also, note that COUNT is a reserved word in most SQL databases, and shouldn't be used as a fieldname.