jetalomar
August 19th, 2002, 23:31
why isn't this query sorting, is something wrong with it?
mysql_query("SELECT players5.id as id, players5.name as name,players5.team as team, players5.id id,
format((sum(players_stats2.ip)+players2.ip),0) ip,
format((sum(players_stats2.h)+players2.h),0) h,
format((sum(players_stats2.r)+players2.r),0) r,
format((sum(players_stats2.so)+players2.so),0) so,
format((sum(players_stats2.w)+players2.w),0) w,
format((sum(players_stats2.l)+players2.l),0) l,
format((sum(players_stats2.s)+players2.s),0) s,
format(((9/(sum(players_stats2.ip)+players2.ip))*(sum(players_stats2.r) +players2.r)),2) era
FROM players_stats2, players5, players2 where players_stats2.id=players5.id and players2.id=players5.id and players5.team='$team' group by players_stats2.id order by ip desc " );
mysql_query("SELECT players5.id as id, players5.name as name,players5.team as team, players5.id id,
format((sum(players_stats2.ip)+players2.ip),0) ip,
format((sum(players_stats2.h)+players2.h),0) h,
format((sum(players_stats2.r)+players2.r),0) r,
format((sum(players_stats2.so)+players2.so),0) so,
format((sum(players_stats2.w)+players2.w),0) w,
format((sum(players_stats2.l)+players2.l),0) l,
format((sum(players_stats2.s)+players2.s),0) s,
format(((9/(sum(players_stats2.ip)+players2.ip))*(sum(players_stats2.r) +players2.r)),2) era
FROM players_stats2, players5, players2 where players_stats2.id=players5.id and players2.id=players5.id and players5.team='$team' group by players_stats2.id order by ip desc " );