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"
displayPageFooter();
exit;
}
$logEntries = LogEntry::getLogEntries($memberId);
displayPageHeader("View member: ".$member->getValueEncoded("firstName")." ".$member->getValueEncoded("lastName"));
?>
-
Username
- <?php echo $member->getValueEncoded("username")?> First name
- <?php echo $member->getValueEncoded("firstname")?> Last name
- <?php echo $member->getValueEncoded("lastname")?> Joined on
- <?php echo $member->getValueEncoded("joinData")?> Gender
- <?php echo $member->getGenderString()?> Favorite genre
- <?php echo $member->getFavoriteGenreString()?> Email address
- <?php echo $member->getValueEncoded("emailAddress")?> Other interests
- <?php echo $member->getValueEncoded("otherInterests")?>
Access log
Web page | Number of visits | Last visit |
---|
$rowCount = 0;
foreach($logEntries as $logEntry){
$rowCount++;
?>
<?php if($rowCount%2 == 0) echo'class="alt"'?>><?php echo $logEntry->getValueEncoded("pageUrl")?><?php echo $logEntry->getValueEncoded("numVisits")?><?php echo $logEntry->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数据表。