当前位置:Gxlcms > PHP教程 > sql语法异常?

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









$rowCount = 0;
foreach($logEntries as $logEntry){
$rowCount++;
?>
>




}
?>
Web page Number of visits Last visit
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数据表。

人气教程排行