set a CSS class for highest number, second highest in MySQL field

[webguync]

Hello,

 

I need to set a CSS class for the highest number in a MySQL column, and the second highest. So for instance I have a column named scores. I would want the <td> with highest scores to be <td.Winner> and the second highest to be <td. RunnerUp>. I know how to set the css part up, so just need help with creating a function. I did something similar to set the background of table cells based on the text data and that looked like this.

function cssfromdate($date) {
$class = array('December_January' => 'January', 'March_April' => 'March');
return $class[$date];
}

while($row = mysql_fetch_array($result))
  {


  echo "<tr>";

  echo "<td>" . $row['last_name'] . "</td>\n";
  echo "<td>" . ucwords($row['first_name']) . "</td>\n";

    echo "<td class=\"".cssfromdate($row['Class_Date'])."\">".$row['Class_Date']."</td>\n";
  
  echo "</tr>";



  }

 

I am hoping I can accomplish what I need to doing something similar.

[vicodin]

When you make your SQL statement use the ORDER BY statement which will allow you to return the data in numeric order and then write a little script to apply what you need to the first 2 pieces of data.