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 '%Educationinfo%';",$connect); $total_fr = mysql_result($query_fr,0,0); $sql_master="select count(*) as cnt,catenum from e_auct_master,(select member.* FROM member,local_area WHERE member.cls_town=local_area.no AND member.related_sites LIKE '%Educationinfo%' AND local_area.country_no=1) as mem WHERE e_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 e_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]; ?>

Foreign Visitors   1. Total No of Foreign Members 2. The best category from Foreign Members