sorry for the late reply, but
PHP Code:
<?
$host = localhost;
$user = your_user;
$dbp = your_pass;
$db = your_db;
mysql_connect("$host", "$user", "$dbp");
mysql_select_db ("$db");
$result = mysql_query("SELECT * FROM "._TABLE_PREFIX_."user WHERE usergroupid=1");
while($i = mysql_fetch_array($result)) {
echo $i['username']."<br>\n";
}
?>
Someone may have found an easier way, but this does indeed work...