variable in sql string causes error

[Anon]

"SELECT * FROM tblServers WHERE SERVER_KEY = $server"

Generates an error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'SERVER_KEY = 13'., SQL state 37000 in SQLExecDirect in c:\program files\apache group\apache\htdocs\svrdetail.php on line 26

Yet the same code substituting the number 13 for $server works fine.

Any ideas?

[van__]

try quoting the var...
"SELECT * FROM tblServers WHERE SERVER_KEY = '$server'"