Page 1 of 1

SQL Query won't run; syntax error?

Posted: Tue Jun 07, 2005 9:46 am
by Reaper
Hi.

I'm having a problem with a SQL query; I'm making a log for my site. It looks like this:

Code: Select all

UPDATE logs SET hits = hits + 1, latest = NOW() WHERE page = index
PHPMyAdmin identifies a syntax error in it, but I can't figure out where it is. I'd be grateful for any help.

-Reaper

Posted: Tue Jun 07, 2005 10:03 am
by timvw

Code: Select all

WHERE page='index'

Posted: Tue Jun 07, 2005 10:08 am
by Reaper
It worked, thanks a lot! :)