Help with a Query...

[GregH_BW]

Here is what I have:

if (!$result = mysql_query("UPDATE auctions SET Rating='$rating' WHERE Key='$id'")) {
print "Could not run query ($query) : " . mysql_error();

} else {
print "Thank you for submitting your vote on this auction!";
}

and here is the error message I get from MySQL

Could not run query () : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Key='1'' at line 1

I can't figure this out. Any help would be appreciated 🙂

[eoghain]

Key is a reserved word in MySQL. I'd guess you have to write your query like so:

UPDATE auctions SET Rating='$rating' WHERE "Key"='$id'

But it could also be that since Key is an integer field (just a guess) that it doesn't like the '' around $id, so:

UPDATE auctions SET Rating='$rating' WHERE Key=$id