Staff page Ranks

[Stephan]

Hello. Can someone help me with my staff page? When I enter this PHP code on my website it shows the rank ID 5 and higher. But I only want the rank ID 5 and not higher and not lower. How to do that? Here's the PHP code:

<?php
    $GetRanks = mysql_query("SELECT id, name FROM ranks WHERE id > '5' ORDER BY id DESC");
    while($Ranks = mysql_fetch_assoc($GetRanks))
    {
        $GetUsers = mysql_query("SELECT username,motto,last_online,online,look FROM users WHERE rank = {$Ranks['id']}");
        while($Users = mysql_fetch_assoc($GetUsers))
        {
                    if($Users['online'] == 1){ $OnlineStatus = "<font color=\"green\">Online</font>"; } else { $OnlineStatus = "<font color=\"red\">Offline</font>"; }
            echo "<img style=\"position:absolute;\" src=\"http://www.habbo.nl/habbo-imaging/avatarimage?figure={$Users['look']}&head_direction=3&direction=3&gesture=sml&action=std&size=b\">"
                ."<p style=\"margin-left:70px;margin-top:40px;\"><strong>{$Users['username']} ({$OnlineStatus})</strong><br>Missie: <i>{$Users['motto']}</i><br><small>Laatste bezoek: ". date("D, d F Y H:i (P)", $Users['last_online']) ."</small></p><br><br>";
        }
        echo "</p><br>";
    }
?>

Thanks for helping.

 

[Legion]

The code you used was

<?php
    $GetRanks = mysql_query("SELECT id, name FROM ranks WHERE id > '5' ORDER BY id DESC");
    while($Ranks = mysql_fetch_assoc($GetRanks))
    {
        $GetUsers = mysql_query("SELECT username,motto,last_online,online,look FROM users WHERE rank = {$Ranks['id']}");
        while($Users = mysql_fetch_assoc($GetUsers))
        {
                    if($Users['online'] == 1){ $OnlineStatus = "<font color=\"green\">Online</font>"; } else { $OnlineStatus = "<font color=\"red\">Offline</font>"; }
            echo "<img style=\"position:absolute;\" src=\"http://www.habbo.nl/habbo-imaging/avatarimage?figure={$Users['look']}&head_direction=3&direction=3&gesture=sml&action=std&size=b\">"
                ."<p style=\"margin-left:70px;margin-top:40px;\"><strong>{$Users['username']} ({$OnlineStatus})</strong><br>Missie: <i>{$Users['motto']}</i><br><small>Laatste bezoek: ". date("D, d F Y H:i (P)", $Users['last_online']) ."</small></p><br><br>";
        }
        echo "</p><br>";
    }
?>

The part you missed was

 WHERE id = '5' ORDER BY id DESC

Just change the code to

<?php
    $GetRanks = mysql_query("SELECT id, name FROM ranks WHERE id = '5' ORDER BY id DESC");
    while($Ranks = mysql_fetch_assoc($GetRanks))
    {
        $GetUsers = mysql_query("SELECT username,motto,last_online,online,look FROM users WHERE rank = {$Ranks['id']}");
        while($Users = mysql_fetch_assoc($GetUsers))
        {
                    if($Users['online'] == 1){ $OnlineStatus = "<font color=\"green\">Online</font>"; } else { $OnlineStatus = "<font color=\"red\">Offline</font>"; }
            echo "<img style=\"position:absolute;\" src=\"http://www.habbo.nl/habbo-imaging/avatarimage?figure={$Users['look']}&head_direction=3&direction=3&gesture=sml&action=std&size=b\">"
                ."<p style=\"margin-left:70px;margin-top:40px;\"><strong>{$Users['username']} ({$OnlineStatus})</strong><br>Missie: <i>{$Users['motto']}</i><br><small>Laatste bezoek: ". date("D, d F Y H:i (P)", $Users['last_online']) ."</small></p><br><br>";
        }
        echo "</p><br>";
    }
?>

 

[Stephan]

Lol So easy. Thank you very much.