column names with spaces

[Anon]

MySQL allows queries of column names that contain spaces as long as the column names are surrounded by backticks (`). For instance the following command:

select team code from teams

will work at the SQL command line, but... when I uses this statement in a query inside a PHP document, I receive the following error:

Parse error: parse error, expecting `T_STRING'

what can I do to display columns names (and the data within) when the particular column name contains a space?

Thanks in advance!!!

[interactive]

try select team code from teams

[Anon]

try `Field Name'

(backtick [field name] single quote)