$query = "
select t1.USER_DISPLAY_NAME,t1.USER_ID,t2.USER_NAME_COLOR,t1.USER_MEMBERSHIP_LEVEL
from {$config['TABLE_PREFIX']}USERS as t1,
{$config['TABLE_PREFIX']}USER_PROFILE as t2
where t1.USER_IS_APPROVED = 'yes'
and t1.USER_IS_BANNED = 0
and t1.USER_ID <> '1'
and t1.USER_ID = t2.USER_ID
order by USER_ID desc limit 5
";
$sth = $dbh->do_query($query);
$users = array();
$i=0;
while(list($uname,$uid,$Color,$PostStatus) = $dbh->fetch_array($sth)) {
$uname = $html->user_color($uname, $Color, $PostStatus);