include("config.php");
include("$header");
if ($id == 'all'){
$query="SELECT * FROM $table WHERE apr='y' ORDER BY $allsort ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
MEMBERS
The complete list (view sorted by country):
ID |
Name |
Email |
URL |
Country |
if ($enablefave == 'Y'){ ?>
Favorite Athlete | } ?>
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
$email=mysql_result($result,$i,"email");
$url=mysql_result($result,$i,"url");
$country=mysql_result($result,$i,"country");
$hide=mysql_result($result,$i,"hideemail");
if ($enablefave == 'Y'){
$fave=mysql_result($result,$i,"fave"); }
$id = sprintf("%03.0f", $id);
echo "[$id] |
$name | ";
if ($hide != "h"){
$array = explode("@", $email);
$first = $array[0];
$last = $array[1];?>
|
} else {
echo "@ | "; }
if ($url == "") {
echo "www | ";
} elseif ($url !== "") {
echo "www | "; }
echo "$country | ";
if ($enablefave == 'Y'){
echo "$fave | ";
} else { echo ""; }
++$i;
}
echo "
"; ?>
} else {
$query="SELECT DISTINCT country FROM $table WHERE apr='y' ORDER BY country ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
COUNTRIES
Members sorted by country (view the complete list):
Country |
Fans |
$i=0;
while ($i < $num) {
$country=mysql_result($result,$i,"country");
$query2="SELECT id FROM $table WHERE apr='y' AND country='$country'";
$result2=mysql_query($query2);
$num2=mysql_numrows($result2);
echo "$country | ";
if ($num2 == "1"){
echo "$num2 fan | ";
} else {
echo "$num2 fans | ";
}
++$i;
}
echo "
";}
include("$footer");
?>