开发者

Unknown column 'a.Email Address' in 'field list' error MySQL

开发者 https://www.devze.com 2023-03-12 06:45 出处:网络
I have the error: Unknown c开发者_C百科olumn \'a.Email Address\' in \'field list in PHP from a database query.

I have the error:

Unknown c开发者_C百科olumn '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'


Quote it:

a.`Email Address`

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号