Hi all, I have just added a field (order) to a table with about 12,000 records.
Now I cannot select or insert unless I quote the field names in the query i.e. This returns - you have an error near 'order ...' SELECT id,pub_date,last_update,type,region,author,title,summary,content,keywords,filename,order FROM articles WHERE id = 23692 but this works fine. SELECT `id`,`pub_date`,`last_update`,`type`,`region`,`author`,`title`,`summary`,`content`,`keywords`,`filename`,`order` FROM `articles` WHERE `id` = 23692 I have no idea why, has the table been corrupted? I'm running MySQL 3.23.48 Thanks, olinux __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.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