<?php
$admin = mysql_query("SELECT * FROM users WHERE rank = '7' ORDER BY rank desc");
while ($admina = mysql_fetch_assoc($admin)) {
?>
<img alt="<?php echo $admina['username']; ?>" src="http://www.habbo.fr/habbo-imaging/avatarimage?figure=<?php echo $admina['look']; ?>.gif&direction=3&head_direction=3&action=wav&gesture=sml">
Username: <?php echo $admina['username']; ?><br />
Motto: <?php echo $admina['motto']; ?><br />
Position: <?php
$getUser = mysql_query("SELECT * FROM users WHERE id ='".$admina['id']."'");
$user = mysql_fetch_array($getUser);
$rankId = $user['rank'];
$getRank = mysql_query("SELECT * FROM ranks WHERE id ='$rankId'");
$rank = mysql_fetch_array($getRank);
echo "".$rank['name']."";
?><br />
</div>
<? } ?>
Didn't work :LJust use CSS to move each box then in each box add:
Code:<?php $admin = mysql_query("SELECT * FROM users WHERE rank = '7' ORDER BY rank desc"); while ($admina = mysql_fetch_assoc($admin)) { ?> <img alt="<?php echo $admina['username']; ?>" src="http://www.habbo.fr/habbo-imaging/avatarimage?figure=<?php echo $admina['look']; ?>.gif&direction=3&head_direction=3&action=wav&gesture=sml"> Username: <?php echo $admina['username']; ?><br /> Motto: <?php echo $admina['motto']; ?><br /> Position: <?php $getUser = mysql_query("SELECT * FROM users WHERE id ='".$admina['id']."'"); $user = mysql_fetch_array($getUser); $rankId = $user['rank']; $getRank = mysql_query("SELECT * FROM ranks WHERE id ='$rankId'"); $rank = mysql_fetch_array($getRank); echo "".$rank['name'].""; ?><br /> </div> <? } ?>
And add that into each box change "7" to each rank and change $admin to anything like $moddd and $admina to anything like $moddda
Only did that quickly, you'd have to style it a bit but that's easy.