variables in sql queries

[Anon]

please someone help me for the life of me i don't understand what i'm doing wrong.

i'm trying to get an email from a database i made.

when i do this:
$testuser = "[dead]nnyx";
mysql_connect($sqlhost, $sqllogin, $sqlpass) or die(mysql_error());
$result = mysql_db_query($dbname, 'SELECT email FROM users WHERE user=$testuser') or die(mysql_error());
it returns the error Unknown column '$testuser' in 'where clause'
but when i change $testuser to "[dead]nnyx" it works (so you can also assume the connection database and table are all setup properly).

what am i doing wrong?

[Anon]

If you want to use variables inside a string, then you need to use double quotes, as in:

"$testuser"

And, because $testuser is a string inside the SQL statement, you need to surround it with quotes also:

"SELECT email FROM users WHERE user='$testuser'"

Diego

[Anon]

thanks man.