Re: mysql query

Hi, Friday, October 3, 2003, 8:17:23 PM, you wrote: CM> ok im stumped lol i have used this code in the past to insert data into CM> mysql (im relitively new though) CM> ------code-------- CM> mysql_query("INSERT INTO Images (Image, desc) VALUES ('$name', CM> '$description')") or die (mysql_error()); CM> --end code--------- CM> but i get this error] CM> ---------error------------- CM> You have an error in your SQL syntax. Check the manual that corresponds to CM> your MySQL server version for the right syntax to use near ''Image', CM> 'desc') CM> VALUES ('2419091.jpg', 'stone')' at line 1 CM> ----------- end error-------------- CM> I found if i just try and record the name value it works fine but if i try CM> to add the description i get the error. CM> Any clues? CM> :) it may be because desc is a reserved word, put it in backticks desc -- regards, Tom