[RESOLVED] ORDER BY

[msnhockey]

i would like to order my results by $pts which isn't in the database.
$pts is goals and assists added together...

is it possible to do or do I have to order by
player_stats.goals or player_stats.assists

$stats_sql = "SELECT * FROM players, player_stats " 
     . "WHERE players.teamid = '".$gm_team2."' AND players.position != 'G' " 
     . "AND players.registered = '1' AND player_stats.playerid = players.id " 
     . "AND player_stats.game_id = '".$id."' AND player_stats.played = '1'" 
     . "ORDER BY '".$pts."' DESC";

[nemonoman]

ORDER BY (player_stats.goals + player_stats.assists)

Yes, this will work.

[msnhockey]

works great... thanks alot..

I didn't realize you could add together like that on a order by
I guess I do learn something everyday..

thanks again.