sql语法错误??
php中文网
发布时间:2016-06-23 14:27:21
|
1494人浏览过
|
来源于php中文网
原创
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
Member not found.
"; displayPageFooter(); exit;}$logEntries = LogEntry::getLogEntries($memberId);displayPageHeader("View member: ".$member->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")?> |
回复讨论(解决方案)
'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数据表。