Posted on Sunday 9th November 2008 at 07:17 PM
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
this is my code
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[username]'>$user[id]</a></td>
<td align="center" width='36%'bgcolor="$class"><a href='gang/view_gang.php?view=$user[gangname]' class='tag'>$user[gangtag]</a> <a href='members.php?user=$user[username]'>$user[username]</a></td>
<td align="center" width='20%' bgcolor="$class">$user[level]</td>
</tr>
</table>");
if($class == $class1){
$class = $class2;
}else{
$class = $class1;
}
$m++;
}
}
$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[username]'>$user[id]</a></td>
<td align="center" width='36%'bgcolor="$class"><a href='gang/view_gang.php?view=$user[gangname]' class='tag'>$user[gangtag]</a> <a href='members.php?user=$user[username]'>$user[username]</a></td>
<td align="center" width='20%' bgcolor="$class">$user[level]</td>
</tr>
</table>");
if($class == $class1){
$class = $class2;
}else{
$class = $class1;
}
$m++;
}
}