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

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資料表。

