Joshua F Posted September 26, 2010 Share Posted September 26, 2010 I have a chatbox I am working on, and it has Username field, and it get the username from the user logged in. So I am trying to make it so that I can make it so staff have different colors/crowns by there name in the box. Here is my code <?php list($crowns) = mysql_fetch_row(mysql_query("SELECT * FROM users WHERE username="'chat'.'username'"")) or die (mysql_error()); while($crn = mysql_fetch_assoc($crowns)) { if($crn['rights'] == 2){ $crownon = 1; $crownurl = 'http://runelegend.com/crowns/admin.gif'; $coloron = 1; $color = '#0066CC'; } elseif ($crn['rights'] == 1) { $crownon = 1; $crownurl = 'http://runelegend.com/crowns/mod.gif'; $coloron = 1; $color = 'red'; } elseif ($crn['rights'] == 0) { $crownon = 0; } else { Die("Error with online list, please contact an administrator."); } } ?> I am trying to make it Select Username from users and then if the chat database has that username, it adds the crowns/colors. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.