HFD Posted August 18, 2008 Share Posted August 18, 2008 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 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 Quote Link to comment Share on other sites More sharing options...
elflacodepr Posted August 18, 2008 Share Posted August 18, 2008 The problem is that, the word "desc" is a reserved word. so you should change "desc" field in your table to something else. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 20, 2008 Share Posted August 20, 2008 Like, say, description. Quote Link to comment Share on other sites More sharing options...
AjBaz100 Posted August 21, 2008 Share Posted August 21, 2008 Yes, or niceTits. Quote Link to comment Share on other sites More sharing options...
bluejay002 Posted August 21, 2008 Share Posted August 21, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.