var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
A little MYsql help.
I'm getting an error running a database command.
The command I am running is
There is an entry in database where repeat does in fact equal Saturday. However when I run that command I get the following error.
select * from raidcal where repeat like 'Saturday'
I can run the command on any other field in the table and return results.
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 'like 'Saturday'' at line 1
Any help would be appreciated.
repeat is a reserved word for mysql.
Put the word in backticks will resolve the error:
select * from raidcal where `repeat` like 'Saturday'
also, why do you decide to use "LIKE" instead of `repeat`='Saturday'?
see list of reserved words here: http://www.htmlite.com/mysql002a.php
Originally Posted by orbitz
Thanks that works perfectly. I also tried to use = however got the same error. Is that a new deal? This was actually on a script that worked fine before, i assume the webhost updated mysql.
you must've left something out. Normally, I would echo out the sql statement and see what is wrong there.