PHP - Moved: Php Mysql Select Highest Quotient

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321437.0

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.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=350716.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=348309.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=318996.0