MySql Query usergroups

[CoolHand_79]

How would I write a MySql query so that it will gather users of a usergroup and print them out on a page?

I want to make a custom pre-written members page.

Thanks,

Luke

[xXSesshomaruXx]

sorry for the late reply, but



<?
$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...

[CoolHand_79]

w00t! Thanks!

Luke