WHERE clause in SELECT statement

[Crimsondrac]

I am having a wierd problem. In a Select statement, I have a WHERE clause similar to:
SELECT * FROM stickers WHERE state=$state

I have some links that have the argument: ?state=TX or ?state=KY.

When it trys to load that argument, I get a:

Error: Unknown column 'TX' in 'where clause'

The column name in MySQL is 'state' but for some reason it thinks TX is the column name. Can anyone tell me what I am doing wrong?

Thanks,

[bradgrafelman]

Just as in PHP or even HTML, when you pass MySQL a string value, you must enclose it in quotes.

[NogDog]

Just to clarify, the PHP would look something like:

$query = "SELECT * FROM stickers WHERE state='$state'";