$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($connect, "SELECT COUNT(*) FROM member,local_area WHERE member.cls_town=local_area.no AND local_area.country_no=1 AND member.related_sites LIKE '%Tradeinfo%';",$connect);
$total_fr = mysql_result($query_fr,0,0);
$sql_master="select count(*) as cnt,catenum from auct_master where (country_no='1') group by catenum order by cnt desc";
$result_master=mysqli_query($connect, $sql_master,$connect);
$rows_master=mysqli_fetch_array($result_master);
$qu_cat="select catename from category where catenum='$rows_master[1]' ";
$re_cat=mysqli_query($connect, $qu_cat,$connect);
$row_cat=mysqli_fetch_array($re_cat); mysqli_free_result($re_cat);
$f_members_cate=$row_cat[catename];
$query_cy="select count(*) as cnr, cc from site_stats group by cc order by cnr desc limit 3 ";
$result_cy=mysqli_query($connect, $query_cy,$connect);
$result_cy_tot = mysqli_num_rows($result_cy);
?>
include("head_href.php"); ?>
|
|
|
|
|
|
|
|
1. Total No of Foreign Members |
|
2. The best category from 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;
} mysqli_free_result($result_cy);
if(!$country_str) {
$country_str = "New Zealand";
}
?>
|
|
|
|
|
|
|
|
![](/images/option_bk4.gif) |
|
|
////print_r($_REQUEST);
include "../include/footer.php";
?>