SQL syntax error??

Query failed:sqlstate[42000]: Syntax error or Access violation:1064 you have a error in your SQL Syntax; Check the manual, 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

  Number of 
     Last 
    
   
    >
    

 
  

  
   

   
    
Web Page
visits
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 a error in your SQL Syntax; Check the manual, 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 Directive is
SELECT field list from table name

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

' Frommembers


From members xxxxx
What do you mean?

is to let you write separately, or from this keyword can not be identified.

' Frommembers


From members xxxxx
What do you mean?

What's the problem?

Please determine if there is a member data table.

