<?php
$name= 'TEST';// put in your name of group if it automatically group_id=1
$result = dbquery("SELECT user_id,user_name, user_groups FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,10");
$result1= dbarray(dbquery("SELECT group_id FROM ".$db_prefix."user_groups WHERE group_name= '$name' "));
$group_id =$result1['group_id'];
echo "<img src='".THEME."images/bullet.gif' alt=''> Users by group <b>$name<b>:";
if (dbrows($result) != 0){
$i=0;
while ($data = dbarray($result)) {
$i++;
$id = $data['user_id'];
$user = $data['user_name'];
$group=explode(".", $data['user_groups']);
while (list($k, $w) = each($group)) {
if ($w==$group_id ){
echo" <a href='".BASEDIR."profile.php?lookup=$id' class='side'>$user

</a>\n";
}
}
}
}
?>