field = order, data not inserting?

2004-05-25 Thread Louie Miranda
I have a field named order i think im missing something obvious, but i cant find it. When i insert something on the field order via PHP, no data on all of my fields are being inserted. But when i tried to change the field name to orders data are now being inserted. Its weird. -- - Louie Miranda

Re: field = order, data not inserting?

2004-05-25 Thread Louie Miranda
well, that explains it. Many thanks! -- - Louie Miranda http://www.axishift.com - Original Message - From: Terry Riley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 3:35 PM Subject: Re: field = order, data not inserting? Probable cause: 'order' is a reserved

Re: field = order, data not inserting?

2004-05-25 Thread Terry Riley
Probable cause: 'order' is a reserved word in MySQL (as used in 'order by'). Terry --Original Message- I have a field named order i think im missing something obvious, but i cant find it. When i insert something on the field order via PHP, no data on all of my fields are