Posted by Matt White on 05/04/07 23:00

Here is my query:

$query = "UPDATE money SET value = '5' WHERE key = 'one'";

When I run the page, the query dies saying:

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 'key = 'one'' at
line 1

The same thing happens when I use INSERT or other functions. I have used
them before, but now I seem to be having troubles. Can anyone find any
mistakes? I'm running XAMPP 1.6.0a on a Windows machine.

[Back to original message]