$top_menu = "commu";
$grey_box = "Community > Site Stats > Foreign Visitors";
$green_box_img = "icon_community.gif";
$green_box = "Site Stats";
include "../include/header.php";
$query_fr=mysqli_query("SELECT COUNT(*) FROM member,local_area WHERE member.cls_town=local_area.no AND local_area.country_no=1 AND member.related_sites LIKE '%Matchinfo%';",$connect);
$total_fr = mysql_result($query_fr,0,0);
$query_cy="select count(*) as cnr, cc from m_site_stats group by cc order by cnr desc limit 3 ";
$result_cy=mysqli_query($query_cy,$connect);
$result_cy_tot = mysqli_num_rows($result_cy);
?>
include("head_href.php"); ?>
| |
|
|
| |
| |
| |
|
| |
| 1. Total No of Foreign
Members |
|
| 3. The Country
visiting most |
$country_str = "";
for($s=0;$s<$result_cy_tot;$s++){
$rows_cy=mysqli_fetch_array($result_cy);
if($s != 0 && $country_str != '') {
$country_str .= " > ";
}
if($rows_cy[1]=="NZ"){ $country="New Zealand";
}elseif($rows_cy[1]=="AU"){ $country="Australia";
}elseif($rows_cy[1]=="US"){ $country="United States";
}elseif($rows_cy[1]=="CA"){ $country="Canada";
}elseif($rows_cy[1]=="IN"){ $country="India";
}elseif($rows_cy[1]=="BR"){ $country="Brazil";
}elseif($rows_cy[1]=="EU"){ $country="Europe";
}elseif($rows_cy[1]=="JP"){ $country="Japan";
}elseif($rows_cy[1]=="CN"){ $country="China";
}elseif($rows_cy[1]=="TH"){ $country="Thailand";
}elseif($rows_cy[1]=="KR"){ $country="Republic of Korea";
}elseif($rows_cy[1]=="MY"){ $country="Malaysia";
}elseif($rows_cy[1]=="SG"){ $country="Singapore";
}elseif($rows_cy[1]=="HK"){ $country="Hong Kong";
}elseif($rows_cy[1]=="DE"){ $country="Germany";
}elseif($rows_cy[1]=="FR"){ $country="France";
}elseif($rows_cy[1]=="CH"){ $country="Switzerland";
}elseif($rows_cy[1]=="IE"){ $country="Ireland";
}elseif($rows_cy[1]=="RU"){ $country="Russian Federation";
}elseif($rows_cy[1]=="NL"){ $country="Netherlands";
}elseif($rows_cy[1]=="PL"){ $country="Poland";
}elseif($rows_cy[1]=="BE"){ $country="Belgium";
}elseif($rows_cy[1]=="GB"){ $country="United Kingdom";
}else{ $country=''; }
$country_str .= $country;
} mysql_free_result($result_cy);
if(!$country_str) {
$country_str = "New Zealand";
}
?>
|
|
|
| |
|
|
|
|
 |
|
|
////print_r($_REQUEST);
include "../include/footer.php";
?>