Topic: help with ordering DB values (Read 1052 times)
aka J Love Community Supporter?
Bill Gates is my home boy
Gender:
Posts: 886
1148 credits Members referred : 4
« on: Aug 11, 2006, 08:18:41 pm »
for some reason when this panel parses it shows it in the wrong order, im using 3 test values to see how it orders it, 0, 91, and 100. it orders it as 91, 100, 0 when it should be 100, 91, 0...
Code:
<?php
$result = dbquery("SELECT user_name, user_clanrank, user_cpts FROM ".$db_prefix."users ORDER BY user_cpts DESC LIMIT 0,5 ");