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); ?>

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