如何从查询结果中打印出最低值？

Question

I have

var_dump($row[Price]);

which prints out all prices from my query ($query = "Select * FROM myTable WHERE...")

like this:

string(5) "37.00" string(5) "20.00" string(5) "23.00" string(5) "12.00" string(5) "10.00"

Now: I would like to print (echo) out just the Lowest Value which is "10.00" in this case.

How do I do this?

Answer 1

while ($row = mysql_fetch_array($result))
{
  // Print out the contents of each row into a table
}

Instead of above codes, use following:

$list = mysql_fetch_array($result);

function _getPrice($array) {
  return $array['Price'];
}

$prices = array_map('_getPrice', $list);

echo min($prices);

Alternative [suggest you]

Or you can get MIN with SQL Query like @Teneff said:

SELECT MIN(price) FROM myTable WHERE...