Newbie Needs Help w/php and sql

[Anon]

Hi, I am just starting to learn php and sql...I have set up a registration form (collects email address, first name, last name, etc). I am able to get all that info from the form to an sql database.

My next step the part im having trouble with. After people register, I want them to be able to log into the site (using their email address), and after doing that, they will get a message like "Welcom Back, Jack", or whatever their first name is.

My question is, how do I grab their first name after they enter their email address? What functions can I use to call that cell in the sql database...thanks.

[Anon]

For all your SQL ponderings:

www.sqlcourse.com

Your final query would look something like:

SELECT first_name from table_name where email='$email'

[Anon]

thanks a lot man, peace