Quantity Rating

[Dysan]

I have a field in the database called "Quantity". How do I find the 10 most highest numbers, then display them on a rating of 1-10. 1being the highest, and 10 being the lowest.

The following code creates the numbers 1-10.

for ($i = '1'; ; $i++)
{
  echo $i . '<br>';
  if ($i == "10")
  {
    echo '<br><br>';
    break;
  }
}

[laserlight]

A relational database? If so, have the database engine do it for you with a ORDER BY Quantity DESC. If your database vendor supports it, you could even add a LIMIT 10 clause.

[Dysan]

No. How do you do it for non relational databases?

[laserlight]

It depends. One naive way that would probably work well enough nonetheless is to load all the needed data into an array, then use [man]usort/man to sort the array. After that you just take the first 10 elements and you're done.