Help selecting a row using variables


#1

I have a table.

Here is what’s in it.

PersonID Firstname Lastname Password (it’s hashed) Email Age

All I know is the users email. Is there a way to select the row that the email is located on?

I want to discover all the contents on that row.

Any help? I really need this.

ALL I NEED

I just need how to select the row that contains the entered email (which is stored in a session)

PLEASE help me!!


#2

Just query the table for the information.
[php]
$qry = mysql_query(“SELECT * FROM table WHERE email = ‘$email’”) or die(mysql_error());
if(mysql_num_rows($qry) != 0) {
$info = mysql_fetch_assoc($qry);

$id = $info[‘PersonID’];
$fname = $info[‘Firstname’];
// etc.
} else {
echo “No users found with that email”;
}[/php]