help on Ordering MySql Query

jambomb · 2008-11-13T00:54:21+00:00

Ok i have big problems trying to order my database, im making a hall of fame and so far its working but just not ordering the users level in order this is my code $get_users = mysql_query("SELECT * FROM `members` ORDER BY `level` DESC); $class1 = "#333333"; $class2 = "#1E1E1E"; $class = $class1; $m = "1"; { while($user = mysql_fetch_array($get_users)) { echo ("<table width=\"75%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\"> <tr> <td align=\"center\" width='20%' bgcolor=\"$class\">$m</td> <td align=\"center\" width='24%' bgcolor=\"$class\"><a href='members.php?user=$online'>$user</a></td> <td align=\"center\" width='36%'bgcolor=\"$class\"><a href='gang/view_gang.php?view=$user' class='tag'>$user</a> <a href='members.php?user=$user'>$user</a></td> <td align=\"center\" width='20%' bgcolor=\"$class\">$user</td> </tr> </table>"); if($class == $class1){ $class = $class2; }else{ $class = $class1; } $m++; } }

Posted on Wednesday 12th November 2008 at 12:39 AM

jambomb

nope im level 10 mate and im not there

Posted on Wednesday 12th November 2008 at 12:39 AM

jambomb

well level 11 now

Posted on Thursday 13th November 2008 at 06:54 AM

jambomb

any help ???