[RESOLVED] WHERE clause problems

[cricher]

SELECT * FROM personal_info WHERE user=$thevariable

What is wrong with sql statement to make it say; Unknown column 'thevariableinfo' in 'where clause'.

It works in other parts of the website, and its not the database it retrives data ok without the where statement.
please help, i dont understand, i have a feeling the answer is gonna be really easy 2.

[tsinka]

Hi,

the single quotes are missing. You need to use single quotes on values of character/string type columns:

SELECT * FROM personal_info WHERE user='$thevariable'

Thomas

[cricher]

thnx, told u it would be something simple