[tbigwood]

hi all

im trying to create a sports standings category, ordering the teams by their winning percentage. my question is: is there a way to sort the teams through the ORDER BY clause and simply add a mathematical equation in it or is it much more complex then that? It must first add the two database columns (wins + loses) then divide the wins, then order the other teams.

team 1 .900
team 2 .800
team 3 .760
etc...


any help?

[job0107]

You mean something like this:

PHP Code:

<?php
mysql_connect("host","userName","password");
mysql_select_db("myDb");
$table="myTable";
$results = mysql_query("select *, substr(round(wins/(wins+loses),3),-5) as percentage from $table order by percentage");
$output = "<table border='1'><tr><th>Teams</th><th>Wins</th><th>Loses</th><th>Winning Percentage</th></tr>";
while($row=mysql_fetch_assoc($results))
{
 $team = $row["teams"] ? $row["teams"] : "&nbsp;";
 $wins = $row["wins"] ? $row["wins"] : 0;
 $loses = $row["loses"] ? $row["loses"] : 0;
 $percentage = $row["percentage"] ? $row["percentage"] : 0;
 $output .= "<tr><td>$team</td><td align='center'>$wins</td><td align='center'>$loses</td><td align='center'>$percentage</td></tr>";
 }
echo $output .= "</table>";
?>

Or maybe sort descending:

PHP Code:

<?php
mysql_connect("host","userName","password");
mysql_select_db("myDb");
$table="myTable";
$results = mysql_query("select *, substr(round(wins/(wins+loses),3),-5) as percentage from $table order by percentage desc");
$output = "<table border='1'><tr><th>Teams</th><th>Wins</th><th>Loses</th><th>Winning Percentage</th></tr>";
while($row=mysql_fetch_assoc($results))
{
 $team = $row["teams"] ? $row["teams"] : "&nbsp;";
 $wins = $row["wins"] ? $row["wins"] : 0;
 $loses = $row["loses"] ? $row["loses"] : 0;
 $percentage = $row["percentage"] ? $row["percentage"] : 0;
 $output .= "<tr><td>$team</td><td align='center'>$wins</td><td align='center'>$loses</td><td align='center'>$percentage</td></tr>";
 }
echo $output .= "</table>";
?>