//$pagelevel = 4;
//include("$protectedpage");
?>
num |
id |
user |
forename |
gender |
loc |
group |
include("$opendatabase");
$query = "SELECT id, user, forename, gender, membergroup, location, country, flag
FROM `tbt_members` , `tbt_countries`
WHERE tbt_members.location = tbt_countries.cid
ORDER BY `tbt_members`.`id` ASC ";
$result = mysql_query($query) or die("Woot? 1" . mysql_error());
$num = mysql_num_rows($result);
for ($i=0; $i<$num; $i++)
{
$id = mysql_result($result,$i,"id");
$user = mysql_result($result,$i,"user");
$user = "$user";
$forename = mysql_result($result,$i,"forename");
$location = mysql_result($result,$i,"location");
$gender = mysql_result($result,$i,"gender");
$group = mysql_result($result,$i,"membergroup");
$country = mysql_result($result,$i,"country");
$flag = mysql_result($result,$i,"flag");
if ($group == 0) { $grouptag == "BANNED"; }
elseif ($group == 1) { $grouptag = "MEM"; }
elseif ($group == 2) { $grouptag = "MEM++"; }
elseif ($group == 3) { $grouptag = "MOD"; }
elseif ($group == 4) { $grouptag = "ADMIN"; }
echo "
$i |
$id |
$user |
$forename |
$gender |
 |
$grouptag |
";
}
?>