Error message

I'm assisting a colleague with a project. I am not using my owner server for this project. It is a GoDaddy host, windows flavor.

I have encountered an error message and not sure what to do to correct.

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 'desc, address1, address2, citycode, city, state, zip, country, phone, fax, name,' at line 1

This is on the Update page and Insert pages.

I can see the records on the results page.

Thanks much.

Someone with more knowledge of mySql than myself will hopefully confirm, but I suspect that the problem you are experiencing arises from the fact that your column name 'desc' is a reserved word in mySql.

You should change that to something else, and you should then be OK.

reserved-words.html

ah! thank you!!

neilo, you are correct, the column name 'desc' is the cause of the problem because it is a reserved word.

'desc' is used for setting the order of the MySQL ORDER BY clause:

options are ascending:
SELECT * FROM table ORDER BY column ASC

or descending:
SELECT * FROM table ORDER BY column DESC

After neilo pointed me in the right direction, I found a handy pdf online for future reference:

sqlreservewords.pdf

Thanks again.

neilo also linked you to the mysql 5.1 reference page which list all of the reserved word:
reserved-words.html


Reserved words change form version to version, so checking the MySQL manual page for your version will give a more complete list.

Yes, thank you again. I wanted to print it out, so the pdf was just a handy "cheat sheet."