当前位置:Gxlcms > PHP教程 > sql语法错误??

sql语法错误??

时间:2021-07-01 10:21:17 帮助过:24人阅读

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
getValueEncoded("firstName")." ".$member->getValueEncoded("lastName"));?>	
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

>
Web page Number of visits Last visit
getValueEncoded("pageUrl")?> getValueEncoded("numVisits")?> getValueEncoded("lastAccess")?>
Back


回复讨论(解决方案)

'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数据表。

人气教程排行