Re: field = order, data not inserting?
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 > being inserted. But when i tried to change the field name to "orders" > data > are now > being inserted. > > Its weird. > > > -- - > Louie Miranda > http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: field = order, data not inserting?
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 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 > > being inserted. But when i tried to change the field name to "orders" > > data > > are now > > being inserted. > > > > Its weird. > > > > > > -- - > > Louie Miranda > > http://www.axishift.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
field = order, data not inserting?
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 http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]