Sort by a math variable inside of a while loop

[Greysoul]

i'm trying to sort by a math variable included in a while loop. obviously if i declare the variable in a loop called from a query...i can't use the order by in the query, or if i can i'm not sure how as i've tried a couple of ways. i've also tried to use sort($kpg) and that didn't quite work as well as i'd hoped. i'm a bit clueless here.

function pkpg(){$score=mysql_query("SELECT * FROM Players WHERE Kills > 0 Limit 0,10");echo "<table>";echo "<tr><th class='th'>Rank</th><th class='th'>Pilot</th><th class='th'>Clan</th><th class='th'>GP</th><th class='th'>KPG</th></tr>";while($ps=mysql_fetch_array($score)){echo "<tr>";echo "<td class='tdp'>" . ++$i . "</td>";echo "<td class='tdp'>" . $ps['Player'] . "</td>";echo "<td class='tdp'>" . $ps['ClanName'] . "</td>";echo "<td class='tdp'>" . $ps['GP'] . "</td>";$kpg= $ps['Kills'] / $ps['GP'];echo "<td class='tdp'>" . $kpg . "</td>";echo "</tr>";}echo "</table>";echo "<br>";}

[ShadowMage]

I think you can just perform the mathematical operation in your query, assign it an alias and order by that.

$score=mysql_query("SELECT *, (Kills/GP) AS kpg FROM Players WHERE Kills > 0 Limit 0,10 ORDER BY kpg");

That should work, I think.

[Greysoul]

looks like the array didn't like that too much, should there be a comma after the *?Warning: mysql_fetch_array(): supplied argument is not a valid MySQL

[justsomeguy]

I believe ORDER BY goes before LIMIT. You can print the error from MySQL if you want to see specifically what it doesn't like though.

[Greysoul]

doh didn't think of that. how do you call that alias name in my actual output code? $kpg isn't working of course.

[justsomeguy]

$ps['kpg']

[ShadowMage]

I believe ORDER BY goes before LIMIT. You can print the error from MySQL if you want to see specifically what it doesn't like though.

Ooops... Wasn't sure about that. Good thing you're here jsg.

[Greysoul]

wow thats really cool, its almost like it images a temporary column lol. thanks for the help.