Hi all, I'm just teaching myself PHP and MySQL. I'm just trying to do a simple conditional:

 

SELECT first_name FROM users WHERE last_name ='Simpsons';

 

but I get this error and can't find a fix:

 

#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 '' at line 1

 

I'm usung phpMyAdmin 2.7.0-pl2 if this helps.

I've been looking into this more and it only seems to bring the error up when there is more than one instance.

 

Can anyone help.

Hello,

 

Please try this.

 

SELECT `first_name` FROM users WHERE `last_name` ='Simpsons';

 

Thanks,

MyDediServer Support