<?php
header('Content-Type: text/html; charset=utf-8');
ini_set('max_execution_time', 300);
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';


// $res_listing_query = $connect->query("SELECT * FROM `ads` WHERE `junk`=0 ORDER BY `adid` ASC LIMIT 100");
// $res_listing_query = $connect->query("SELECT * FROM `ads` WHERE `junk`=0 GROUP BY county_name, town_name ORDER BY `county_name` ASC");
$res_listing_query = $connect->query("SELECT * FROM `ads` WHERE active='1' AND town_name != '' GROUP BY county_name, town_name ORDER BY `county_name` ASC");
// $res_listing_query = $connect->query("SELECT * FROM `ads` WHERE `adid`=29962");
// $res_listing_query = $connect->query("UPDATE `ads` SET `junk`=0");
// echo "done";
// die();

echo "<b>ads_sqlquery_group_by: </b> SELECT * FROM `ads` WHERE active='1' AND town_name != '' GROUP BY county_name, town_name ORDER BY `county_name` ASC"."<br>";

if($res_listing_query->num_rows > 0){
    echo '<pre>';
    while($row_listing = $res_listing_query->fetch_array(MYSQLI_ASSOC)){
        $adid = $row_listing['adid'];
        $town_name = $row_listing['town_name'];
        $county_name = $row_listing['county_name'];


        // echo "<b>adid: </b>".$adid."<br>";
        // echo "<b>location: </b>".$county_name;

        $match = 1;
        
        $search_loc = $connect->query("SELECT * FROM `towns_new` WHERE r_county_name LIKE '$county_name' AND stripped_name LIKE '$town_name'");
        if(! $search_loc->num_rows){
            $match = 0;
        }
        
        if($match){
            // echo "<b>adid: </b>".$adid."<br>";
            // echo "<b>county_name: </b>".$county_name."<br>";
            // echo "<b>town_name: </b>".$town_name;
            // echo " - [FOUND]"."<br><br>";
        } else{
            echo "<b>adid: </b>".$adid."<br>";
            echo "<b>county_name: </b>".$county_name."<br>";
            echo "<b>town_name: </b>".$town_name;
            echo " - [<b>TOWN NOT FOUND</b>]"."<br>";
            echo "<b>match_with_county_town_query: </b> "."SELECT * FROM `towns_new` WHERE r_county_name LIKE '$county_name' AND stripped_name LIKE '$town_name'"."<br><br>";

        }

    }

} else{
    // echo "All completed";
}