[SOLVED] Why won't this mysql line work?

[AStrangerWCandy]

Having the php program print out the mysql query it generates, and it looks fine.

 

INSERT INTO users (user_Id, userName, pass, firstName, lastName, country) VALUES (id4a99b9563701d, abcd, abcd, abcd, abcd, United States)

 

I cut and paste this line into phpmyadmin on the proper database and get

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'States)' at line 1

 

The columns match up perfectly in case and letters. All are VARCHAR 30 or higher

[peranha]

INSERT INTO users ('user_Id', 'userName', 'pass', 'firstName', 'lastName', 'country') VALUES ('id4a99b9563701d', 'abcd', 'abcd', 'abcd', 'abcd', 'United States')

 

try that, it is because of the Space between Unite and States.

[AStrangerWCandy]

Thanks, what was it! However now that I removed the space  I submit this:

 

INSERT INTO users (user_Id, userName, pass, firstName, lastName, country) VALUES (id4a99b9563701d, abcd, abcd, abcd, abcd, UnitedStates)

 

and its giving me an error stating

 

#1054 - Unknown column 'id4a99b9563701d' in 'field list'

[AStrangerWCandy]

nm, figured it out, thanks again!

[PFMaBiSmAd]

String data must be enclosed in quotes to make them strings instead of being treated as keywords or column names and column names are not enclosed in quotes as that would make them strings.