sql语法异常?
时间:2021-07-01 10:21:17
帮助过:6人阅读
sql语法错误??
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
require_once("common.inc.php");
require_once("config.php");
require_once("Member.class.php");
require_once("LogEntry.class.php");
$memberId = isset($GET_["memberId"])?(int)$_GET("memberId"):0;
if(!$memberId = Member::getMember($memberId)){
displayPageHeader("Error");
echo" 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 |
---|
$rowCount = 0;
foreach($logEntries as $logEntry){
$rowCount++;
?>
>
getValueEncoded("pageUrl")?> |
getValueEncoded("numVisits")?> |
getValueEncoded("lastAccess")?> |
}
?>
Back
displayPageFooter();
?>
分享到:
------解决方案--------------------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 指令解析器如何能认得他们?
------解决方案--------------------就是让你分开来写,不然FROM这个关键字识别不出来的。
------解决方案--------------------请确定是否存在Member数据表。