Reputation: 4820

SQL Query not ordering results properly

I'm querying my database to return a set of results from highest to lowest. But, it seems as if the query isn't entirely ordering the results that way. My code is as follows:

$query = mysql_query("SELECT * FROM ".$stats_table." ORDER BY ppg DESC")or die(mysql_error());
$count = mysql_num_rows($query);
$i = 0;

while($row = mysql_fetch_assoc($query)) 
{
$team[$i] = $row['team'];
    $ppg[$i]  = $row['ppg'];

    $i++;
}

for($i=0;$i<$count;$i++)
{
echo "".$ppg[$i]." <br /><br />";
}

When I echo out the ppg column set I get the following:

It seems that for all of the values less than 100 and over 100 it works. But, how can I make this order work with all values instead of just within those less than and above 100?

Thanks,

Lance

Upvotes: 0

Answers (4)

Emil Hemdal

Reputation: 628

You could let PHP sort it.

$query = mysql_query("SELECT * FROM ".$stats_table)or die(mysql_error());

$i = 0;
while($row = mysql_fetch_assoc($query)) {
    $team[$i] = $row['team'];
    $ppg[$i]  = (int)$row['ppg'];
    $i++;
}
sort($ppg, SORT_NUMERIC);
for($i=0;$i<count($ppg);$i++) {
     echo $ppg[$i]." <br /><br />";
}

Upvotes: 0