Can't select certain field?

[HFD]

Hi, I'm having a slight problem with my SQL query. I am using it to display a list of 'tutorials' (rows) in the database (Using PHP), and for some reason my Select statement doesn't let me select a certain field - It selects it fine when I use SELECT * FROM tutorials, but if I actually change * to the values (Which I need to do to apply WHERE clauses I believe) then it errors on the desc field, saying

 

  Quote

 

Error : 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,image FROM tutorials' at line 1

 

The code I'm using that errors is

 

SELECT tutid,catid,title,desc,image FROM tutorials

 

The table has the following fields:

 

tutid (int)

catid (int)

title (text)

desc (text)

image (varchar)

content (text)

 

The 'content' is only outputted when a tutorial is chosen.

 

Thanks

 

[elflacodepr]

The problem is that, the word "desc" is a reserved word. so you should change "desc" field in your table to something else.

[fenway]

Like, say, description.

[AjBaz100]

Yes, or niceTits.

[bluejay002]

You can also add this character as padding to both ends "`" to the field to make it valid. But I do not really recommend this method unless a lot of strings are already attached. Otherwise, their suggestion is defintely better.