[SOLVED] Find Highest Value

[MoFish]

Hello.

 

Im trying to find the highest value of a value in my database called LeagueWoodenSpoon.

 

On the highest value, i want to set $image="spoon.gif"

 

i tryed the following code, but it adds a spoon.gif to everything over 0 and not only the highest value

 

can anyone point me in the right direction?

 

the following code is inwith a loop which goes through every value in my database.

 

$SpoonFlag = 0;

if($row_SelectAllLeague['LeagueWoodenSpoon'] > $SpoonFlag){
  $SpoonFlag = $row_SelectAllLeague['LeagueWoodenSpoon'];
  $image='spoon.gif';
}

[taith]

http://www.tizag.com/mysqlTutorial/mysqlmax.php

[MoFish]

echo "The most expensive  is " . $row_SelectAllLeague['MAX(LeagueWoodenSpoon)'];

 

Notice: Undefined index: MAX(LeagueWoodenSpoon) in D:\league.php on line 48

 

hmm

[paul2463]

try in your query a something like this

 

$query = "SELECT *, MAX(LeagueWoodenSpoon) AS spoon FROM table";

echo "The most expensive  is " . $row_SelectAllLeague['spoon'];