Error in SQL syntax

[biscutty]

Could someone tell me what is wrong with my query..
I have echo'd the $msg portion of my query for error checking below...

INSERT INTO orders ( MNAME, ORDER, TOTAL ) values( 'adamblake', 'adamblake - Retouching of image: 44_A85T1214 Black and White@ 9.95 - Instructions for: 44_A85T1214: - Retouching of image: 297_A85T1202 Black and White@ 9.95 - Instructions for: 297_A85T1202: swadasdf - Retouching of image: 486_A85T1144 Black and White@ 9.95 - Retouching of image: 486_A85T1144 Colour@ 9.95 - Instructions for: 486_A85T1144: sadfasdf - Retouching of image: 504_A85T1138 Black and White@ 9.95 - Instructions for: 504_A85T1138: - Total: 19.90 - Monday 01st of December 2003 11:58:07 PM', '19.90')

Couldn't add data to the Database table: You have an error in your SQL syntax near 'ORDER, TOTAL ) values( 'adamblake', 'adamblake - Retouching of image: 44_A' at line 1

Thanks

[jsim]

make a respect to reserved words like an "ORDER" 🙂

[biscutty]

aaahhh, thanks for that.. working now

[jsim]

Then this is the right time to mark this thread as "resolved"...