On Tuesday 22 April 2003 18:24, John W. Holmes wrote: > > Database 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 'dec='' WHERE id='1'' at line 1 > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html > #Reserved_words > > DEC is a reserved word. Choose another column name. Or enclose it with backticks (`): UPDATE software SET title='$ud_title', `dec`='$un_dec' ... -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* Have no friends not equal to yourself. -- Confucius */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
