guys.. I hv created a table called "user" for logging purpose.. which has user_id, user_name,user_password and user_Type fields.. I've set user_id to auto increment..

after tht I've try to insert a record via sql window located in phpmyadmin.. I've try to insert the record by giving following query..

INSERT INTO user(user_name,user_password,user_type)
VALUES (smith,smith123,str)

but it has returned a error message like this.

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

so wht's wrong with my query... please help me..

Shouldn't smith be in quotes?
Not sure if str is a variable or a string - if it's a string then it should be in quotes also.

yeah.. i found the mistake..
the query should be

INSERT INTO user(user_name,user_password,user_type)
VALUES ('smith','smith123','str')

thnk u for the idea mike