Extracting just one record

[mrgrammar]

I have a table with one double(5,2) field that contains a bid that is input by users. I need to get just the record that has the highest bid. How do I write the query?

$getiteminfo = "SELECT bidamount FROM bids WHERE

$getitemsrec = mysql_db_query($dbname, $getiteminfo);

while ($qryactive = mysql_fetch_array($getitemsrec))
{
echo $qryactive[bidamount]."<br>";
}

The line above: echo $qryactive[bidamount]."<br>";
should show only one number, the top bid.

Mr. Grammar

[superwormy]

$query = "SELECT * FROM bids ORDER BY bitamount LIMIT 1";
$result = mysql_query ($query) or die (mysql_error ());
$array = mysql_fetch_array ($result);

print ($array['bitamount']);

One of many ways to do it...

You don't need to loop through, 'cause you're only selecting one record. LIMIT 1 in SQL will limit the number of records returned to 1 record.