I have this query in one of my pages:
$query = mysql_query("SELECT Id, team, points, games, gf, ga FROM standings ORDER BY points desc") or die(mysql_error());
The page is a soccer page, where the query above gets the information from the rows and orders it by the points that each team has.
Now that the teams have points with 2 digit numbers (ie: 11, 14), the standings look like:
- Team A - 9 points
- Team B - 7 points
- Team C - 3 points
- Team D - 13 points
- Team E - 1 point
So what's happening, the query is ordering the results not in a proper descending way. It puts the double digits on top of the last team, and not in first place..
How can I fix this error?!
Thanx in advance