Untitled

<?
$username="MYSQL USERNAME";
$password="MYSQL PASSWORD";
$database="DATABASE";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM `phpbb_users` WHERE group_id = 7 OR group_id = 3 OR group_id = 2 OR group_id = 9 OR group_id = 11 OR group_id = 4 OR group_id = 8 OR group_id = 5 ORDER BY group_id, username";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<body bgcolor=Silver>\n";

echo "<p><b><center>Database Output</center></b></p>\n";

echo "<table border=1>\n";

$i=0;
while ($i < $num) {

$username=mysql_result($result,$i,"username");
$group_id=mysql_result($result,$i,"group_id");

echo "<tr><td id=group_id>$group_id</td><td id=username>$username</td></tr>\n";

$i++;
}

echo "</table>\n";
echo "</body>";

?>