SQL INSERT提供“无效查询：未知列”

Question

I need to put into database a $username, but my query gives me Invalid query: Unknown column ....

This is my query:

"INSERT INTO `user`(`screen_name`) VALUES (".$userName.")" 

Anyone can help me?

Answer 1

There are no quotes at the string.

"INSERT INTO `user`(`screen_name`) VALUES ('".$userName."');" 

Add the semi-colon at the end but it is not always necessary.