How can I echo one value from a mysql database in PHP?

  • Thread starter Thread starter H
  • Start date Start date
H

H

Guest
Hi, I am a PHP newbie, and I wanted to know how to echo just one value from mysql.

I have tried this, but it prints all of the values from the MemberID column instead of the last one, which is what I want:

$memberid = mysql_query("SELECT MemberID FROM members
WHERE EmailAddress = '$email' AND Password = '$password'");

while($row = mysql_fetch_array($memberid))

{
echo $row['MemberID'];
echo "< br />";
}

Thanks in advance.
thanks steve - sorted!
 
Back
Top