Get info from specific user

[jumby]

Hi Guys, I am fairly new to mySQL/PHP and I have an issue. I have a login/registration system for a website and it works. However in the registration the user enters info such as their phone and email. How can I access these two fields of info from the user who is currently logged in. For example someone makes an account with:

Username: Person

Password: hello

Email: person@gmail.com

Phone: 111-111-1111

Name: Hello Person

 

When they log into the site using their username and password, how can I detect their email/phone/name? Thanks in advance!

[Oziam]

Query your database accordingly;

 

e.g

 

$query = "SELECT phone,email FROM users WHERE username = '$username' AND userpass = '$userpass' ";

 

$res = mysql_query($query) or die(mysql_error());

 

if(mysql_num_rows($res) > 0){

$data = mysql_fetch_array($res, MYSQL_ASSOC);

 

$phone = $data['phone'];

$email = $data['email'];

}

[jumby]

Thank you so much! It worked perfectly!