“字段列表”中的未知列'a.Email Address'错误MySQL

Question

I have the error:

Unknown column 'a.Email Address' in 'field list in PHP from a database query.

Please can you tell me why it doesn't like the fact that I have a space between Email and Address, and how I can fix it.

Here's my full query:

SELECT f.*, a.*, a.Email Address, a.Avatar 
FROM Following as f 
JOIN Accounts as a ON f.followingUserID = a.id 
WHERE followingUserID = '$acID'

Answer 1

Quote it:

a.`Email Address`

And avoid spaces (or dashes, or reserved words) in/as table/column names.