SQL syntax error ??

SQL syntax error ?? 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")?>
 
   
  
  
 
 
Back
 

Reply to discussion (solution)

'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

The basic format of the select command is
SELECT field list FROM table name

How can the SQL command parser recognize FROM and members when you stick them together?

'Frommembers


FROM members xxxxx
What do you mean?

Is to let you write separately, otherwise the FROM keyword cannot be identified.

'Frommembers


FROM members xxxxx
What do you mean?

What's the problem?

Check whether the Member data table exists.