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 '%Foodinfo%';",$connect); $total_fr = mysql_result($query_fr,0,0); $sql_master = "(SELECT catenum,count(*) as cnt FROM f_resturant,(SELECT member.* FROM member,local_area WHERE member.cls_town=local_area.no AND member.related_sites LIKE '%Foodinfo%' AND local_area.country_no='1') as mem WHERE f_resturant.seq_num=mem.seq_num GROUP BY catenum) UNION (SELECT catenum,count(*) as cnt FROM f_grocery,(SELECT member.* FROM member,local_area WHERE member.cls_town=local_area.no AND member.related_sites LIKE '%Foodinfo%' AND local_area.country_no='1') as mem WHERE f_grocery.seq_num=mem.seq_num GROUP BY catenum) UNION (SELECT catenum,count(*) as cnt FROM f_recipe,(SELECT member.* FROM member,local_area WHERE member.cls_town=local_area.no AND member.related_sites LIKE '%Foodinfo%' AND local_area.country_no='1') as mem WHERE f_recipe.seq_num=mem.seq_num GROUP BY catenum) ORDER BY cnt DESC LIMIT 1;"; $result_master=mysqli_query($sql_master,$connect); $rows_master=mysqli_fetch_array($result_master); $qu_cat="select catename from f_category where catenum='$rows_master[catenum]' "; $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 f_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