I've got a slight problem with my football league. If you click on the link below it will take you to a screenshot of my league table.

http://picasaweb.google.co.uk/lh/photo/Qa7iegVmljlq7NgfBQN00Q?feat=directlink

As you can see from the image the two teams have identical records, now in a normal football league if this happens to be the case then the team whose letter appears first in the alphabet should be above the team whose letter comes later on in the alphabet.

In this example the letter "L" comes before the letter "M" in the alphabet so therefore Leicester City should be in position 1 and Manchester United in position 2 in the league table, currently this isn't the case, is there a way to rectify this problem.

I hope you are able to follow what I'm trying to say and thank you in anticipation of a reply.

Quote:I've got a slight problem with my football league. If you click on the link below it will take you to a screenshot of my league table.

http://picasaweb.google.co.uk/lh/photo/Qa7iegVmljlq7NgfBQN00Q?feat=directlink

As you can see from the image the two teams have identical records, now in a normal football league if this happens to be the case then the team whose letter appears first in the alphabet should be above the team whose letter comes later on in the alphabet.

In this example the letter "L" comes before the letter "M" in the alphabet so therefore Leicester City should be in position 1 and Manchester United in position 2 in the league table, currently this isn't the case, is there a way to rectify this problem.

I hope you are able to follow what I'm trying to say and thank you in anticipation of a reply.


I could also need some help with this problem. The only difference, is that the league hasn't started yet, so my table only containes the team names and the value '0' in every field. It would be nice if the table automagicaly sorted the output by the team names, i.e.
1. Arsenal 0 0-0 0 (team_id=2)
2. Blackburn 0 0-0 0 (team_id=3)
3. Chelsea 0 0-0 0 (team_id=1)

instead of
1. Chelsea 0 0-0 0 (team_id=1)
2. Arsenal 0 0-0 0 (team_id=2)
3. Blackburn 0 0-0 0 (team_id=3)

My experience is that the output is made by in which order you register the teams.

I've tried to change "ORDER BY" in /components/com_bearleague/views/ltable/view.html.php from 'id' to 't_name DESC', but nothing happens.
Code:$query = "SELECT * FROM #__bl_seasons WHERE s_id = ".$s_id." ORDER BY t_name DESC";

Can someone please help me here?
Thank you!