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', '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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
