Normal MySQL update not working...

[koolkeath]

can anyone see whats wrong with this MySQL insert script:

INSERT INTO importedList (BUSINESS, PHONE, PHONE2, CATEGORY_ ID1, CATEGORY_ID2, SUB_ID1, SUB_ID2, SUB_ID3, ROAD, SALES_AREA, SHOPPING_CENTER, ROAD_NUMBER, HOURS, DESCRIPTION, LOGO, LISTING_ID, BANNER_ID, MAIN_BANNER, SIDE_BANNER) VALUES ('A Dollar ', '704-979-1046', NULL, '8', NULL, '5', NULL, NULL, 'Concord Mills', 'Lavis', 'Concord Mills', NULL, NULL, NULL, NULL, '0', '0', NULL, NULL);

[Lats]

can anyone see whats wrong with this MySQL insert CATEGORY_ ID1,There's a space there.

[koolkeath]

There's a space there.


I knew it was something simple, thank you.

[Lats]

I knew it was something simple, thank you.You're welcome. :)

Mysql isn't very helpful with the error messages is it :D

[koolkeath]

You're welcome. :)

Mysql isn't very helpful with the error messages is it :D


Not at all, but I am used to learning languages that are not helpful with error messages, as use to it as i can be. But I am learning. My server's admin is pretty helpful.

-jason