MySQL = Get moderation tickets & Bans?

[UartigZone]

Hello,

I can't get users_bans and moderation_tickets to the users ? I'm stuck...

            <div id="container">
                <div id="content" style="position: relative" class="clearfix">
                    <div id="column1" class="column">
                        <?php
                            $GetTrusted = mysql_query("SELECT * FROM users WHERE exstaff = 1 ORDER BY id DESC");
							
							$GetRanks = mysql_query("SELECT id,name FROM ranks WHERE id > 4 ORDER BY id DESC");
							 
							
                                echo "<div class=\"habblet-container \"><div class=\"cbb clearfix blue \"><h2 class=\"title\">Tidligere ansatte på Stjerne</h2><div style=\"padding:5px\"><p>";
                                while($Dealers = mysql_fetch_assoc($GetTrusted))
                                {
									
								while($Ranks = mysql_fetch_assoc($GetRanks))


																$Bans = mysql_query("SELECT * FROM `users_bans` WHERE `added_by` = '" . $Users['username'] . "'");
                                                                $BanCount = mysql_num_rows($Bans);
                                                                                                       
                                                                $Tickets = mysql_query("SELECT * FROM `moderation_tickets` WHERE `moderator_id` = '" . $Users['id'] . "'");
                                                                $TicketsCount = mysql_num_rows($Tickets);									
									
                                    if($Dealers['online'] == 1){ $OnlineStatus = "<font color=\"darkgreen\"><b>Online</b></font>"; } else { $OnlineStatus = "<font color=\"darkred\"><b>Offline</b></font>"; }
                                    echo "<img style=\"position:absolute;\" src=\"http://www.habbo.com/habbo-imaging/avatarimage?figure={$Dealers['look']}&size=m&action=crr=6,wav&direction=2&head_direction=3&gesture=sml\">"
                                        ."<p style=\"margin-left:80px;margin-top:20px;\">Brugernavn: <strong>{$Dealers['username']}</strong><br><strong>Bans: </strong>$BanCount | <strong>SOS'er Besvaret: </strong>$TicketsCount   </br>Var ansat som: <strong>{$Dealers['position']}</strong><br>Var ansat i perioden: <strong>{$Dealers['stilling']}</strong><br><small>Sidst Online: ". date("D, d F Y H:i (P)", $Dealers['last_online']) ."</small></p>"
                                        ."<p style=\"float:right;margin-top:-30px;margin-right:5px;\">{$OnlineStatus}</p><br><br><br>";
                                }
                                echo "</div></div></div>";
                        ?>
                        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    </div>

Will give 1 +rep to the one how can help

[MentaL]