Order by Desc
Posted: Sun Jul 10, 2011 4:47 am
Hi
I want to display my records order by DESC but I have problem
my query is
and this dispaly records like that
China 6
Danish 3
Italy 4
English 2
Argentine 0
It must show
China 6
Italy 4
Danish 3
English 2
Argentine 0
Please help what is wrong
thanks
I want to display my records order by DESC but I have problem
my query is
Code: Select all
$gamesqry="select team.*,sum(scores.score) as score from tbl_teams team,tbl_result scores where scores.team_id=team.team_id group by team.team_id order by scores.score DESC";China 6
Danish 3
Italy 4
English 2
Argentine 0
It must show
China 6
Italy 4
Danish 3
English 2
Argentine 0
Please help what is wrong
thanks