Registration Mysql problems

[james1892]

Hello, i am attempting to learn php, and have been following a tutorial on you tube http://www.youtube.com/watch?v=jrgHTDefB5Y&watch_response,

The code seems to run ok upto when i try to get mysql and php to work together.

when i run the register action i recive message

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 '= FROM 'users' WHERE 'username' ='james1892@ntlworld.com'' at line 1


Help greratly appriciated thanks

[Newsgroup_User]

james1892 wrote:

> SELECT = FROM 'user' WHERE 'username' ='$username'

It should be something like

SELECT * FROM 'user' WHERE 'username' ='$username'

where * is for all fields. You may select one field like

Select uername from user where 'username' ='$username'

--