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 '%Serviceinfo%';",$connect); $total_fr = mysql_result($query_fr,0,0); $sql_master="select count(*) as cnt,catenum from sv_s_auct_master,(select member.* FROM member,local_area WHERE member.cls_town=local_area.no AND member.related_sites LIKE '%Serviceinfo%' AND local_area.country_no=1) as mem WHERE sv_s_auct_master.seq_num = mem.seq_num group by catenum order by cnt desc"; $result_master=mysqli_query($sql_master,$connect); $rows_master=mysqli_fetch_array($result_master); $qu_cat="select catename from sv_category where catenum='$rows_master[1]' "; $re_cat=mysqli_query($qu_cat,$connect); $row_cat=mysqli_fetch_array($re_cat); $f_members_cate=$row_cat[catename]; $query_cy="select count(*) as cnr, cc from sv_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); ?>

Foreign Visitors   1. Total No of Foreign Members 2. The best category from Foreign Members 3. The Country visiting most