[SOLVED] mysql query help

[perezf]

How can i call one value out of a database

for instance i have these fields in my database

memberid, emailaddress, password, firstname, lastname, gender

 

I have the emailaddress

now i want to know how to print the firstname giving the email address

 

 

 

[SammyGunnz]

Wait...did I understand your question right?

 

<?php

  $query = $db->query("SELECT `firstname` FROM `table` WHERE `emailaddress`='$user[emailaddress]'");

?>

[perezf]

yes thank you