bazmati

Yeah i've inputted exactly that. Everything else I'm working on is fine, just this one thing. Going to give it a try on my pc at home and see if it works ok on that. Thanks for your help Maq.

I've attached a screen shot is this what you want to see, sorry if this is an obvious question I've only just started to learn. [attachment deleted by admin]

Hi Maq yes I'm querying in phpMyAdmin, if i want to select and show all records its fine it shows them all, but as soon as I try to narrow it down anything with more than one record comes up with an error.

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 if there is going to be more than one record returned: #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 using phpMyAdmin 2.7.0-pl2 if this helps.