2 Pretty Basic Problems

[Nixon]

Hi I have two problems. I current own a site called 'Outlink'. This site is an online ranking board for a game called 'Outwar'. To get higher in the ranking board people have to earn more points. I come across a problem when people earn more that 9 points. When people earn more than 9 points they dissapear to the bottom of the leader board. I think this is because it is only using the first digit of the number. Here is an example:

9
95
8
85
5
4
27
1
10

I am using the a mysql query and its using the 'ORDER BY' function. Its somethign like this:

select * from outwarinfo order by points limit 0,5

Now for my second problem I want to use an addition sum within a link like this:

print "<a href=\"page.php?number=$num1+20\">Next</a>"

Any solutions to either of them?

[laserlight]

Well, PHP has a natsort() function.
Still, why dont you store the points as INT ?
My guess is that you are storing as VARCHAR or something.

[Nixon]

Right thanks, that sorted the rankings part how about the link?

[laserlight]

print '<a href="page.php?number=' . $num1+20 . '">Next</a>';