sql语法错误??

原创

2016-06-23 14:27:21955浏览

 Member not found.

Username

getValueEncoded("username")?>

First name

getValueEncoded("firstname")?>

Last name

getValueEncoded("lastname")?>

Joined on

getValueEncoded("joinData")?>

Gender

getGenderString()?>

Favorite genre

getFavoriteGenreString()?>

Email address

getValueEncoded("emailAddress")?>

Other interests

getValueEncoded("otherInterests")?>

Access log

回复讨论(解决方案)

'FROMmembers


FROM members xxxxx

Query failed:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' FROMmembers WHERE id = 0' at line 1

select 指令的基本格式是
SELECT 字段列表 FROM 表名

你把 FROM 和 members 粘在一起，SQL 指令解析器如何能认得他们？

'FROMmembers


FROM members xxxxx
啥意思啊

就是让你分开来写，不然FROM这个关键字识别不出来的。

'FROMmembers


FROM members xxxxx
啥意思啊

这又是什么问题啊

请确定是否存在Member数据表。