olinux, Monday, October 14, 2002, 12:42:21 PM, you wrote: o> I have just added a field (order) to a table with o> about 12,000 records.
o> Now I cannot select or insert unless I quote the field o> names in the query o> i.e. This returns - you have an error near 'order ...' o> SELECT o> id,pub_date,last_update,type,region,author,title,summary,content,keywords,filename,order o> FROM articles WHERE id = 23692 o> but this works fine. o> SELECT o> `id`,`pub_date`,`last_update`,`type`,`region`,`author`,`title`,`summary`,`content`,`keywords`,`filename`,`order` o> FROM `articles` WHERE `id` = 23692 o> I have no idea why, has the table been corrupted? Nope, 'order' is a reserved word: http://www.mysql.com/doc/en/Reserved_words.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php