New To PHP... Simple Question

[Anon]

all this is over my head... what i want to know is this
i have an input field
i want to look in my database for the information enterd in that field then (ie. an e-mail address) then find a corisponding field (ie. username) and place that in a variable like $username

end result You enter e-mail i tell you username

[Anon]

Assuming MySQL here...

<?php
$query = "select username from usertable where email = '$users_email'";
$result = mysql_query($query);

$user = mysql_result($result,0,"email");
echo("$user");
?>

Other things assumed:
1) you've already connected to your db.
2) you won't copy my sql statement verbatim (ie. change it to work with your tables/field names)
3) in your db, the "email" field is unique and thus will never belong to more than one record.

--Ryan

[Anon]

Ack, sorry, typo. The "$user = ..." statement should read:

$user = mysql_result($result,0,"username");

Sorry 🙂