Page 2 of 2

Posted: Mon Jul 16, 2007 1:00 pm
by m2babaey
Begby wrote:order is a reserved word, you will need to use backticks to delimit it. In the future remember that that is a very bad name to use for a field along with other names like select, desc, where etc.

backticks are on the tilda key on the upper left of your keyboard, it should look like `order`='value'
thanks
this was the only problem
SUCCESS!

Posted: Mon Jul 16, 2007 1:11 pm
by RobertGonzalez
Keep in mind too, that you may want to leave quotes off of integer values. MySQL does not enforce strict typing on data yet, but if it grows up a little more it might. Future versions may require that integers not be cast to string values using the quotes around them.