[RESOLVED] Largest value in loop

[zzz]

I wrote a script to get the count of particular occurances per month. Now I'd like to build a bar chart and convert each number into % of the bar.

What I'd like to do is also use the largest number as 100%. How do I do that?

Here's what I've got so far:

$stats= $db->get_results (" query ");
foreach ($stats as $st)
	{

 	echo "<td>".$st->COUNT."</td>";
}

So how do I tell the largest value in the loop? It's been a long day and my brain is totally flat...

[gammaster]

$stats= $db->get_results (" query "); 
$largestValue = 0;

foreach ($stats as $st)  { 

   if($st->COUNT > $largestValue)
      $largestValue = $st->COUNT;

   }

echo $largestValue;

[zzz]

The best solutions are always the simplest, aren't they? Perfect!

🙂

[Weedpacket]

...or if that's all you're after, "SELECT MAX()..."