Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory :  /home/u107206879/domains/escort46.de/public_html/services/search/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
	include "../../db_connection.php";
	include "../../functions.php";
	if(isset($_POST) && !empty($_POST)){
		$whereCondition = $_POST['where_condition'];
		$fix_category = $_POST['fix_category'];
		$ucw_category = $_POST['ucw_category'];
		$mob_more_view_cities_li = $_POST['mob_more_view_cities_li'];
		$districtQuery = mysqli_query($connection,"SELECT place, num_place FROM (SELECT DISTINCT adv.sub_country AS place, count(adv.sub_country) AS num_place FROM advertise AS adv WHERE $whereCondition adv.sub_country!='' AND adv.adstatus=1 AND adv.isApproved=1 GROUP BY adv.sub_country UNION SELECT DISTINCT adv.district AS place, count(adv.district) AS num_place FROM advertise adv WHERE $whereCondition adv.district!='' AND adv.adstatus=1 AND adv.isApproved=1 GROUP BY adv.district) x GROUP BY place ORDER BY num_place DESC, place ASC");
		while($districtResult=mysqli_fetch_assoc($districtQuery)){
	?>
			<li class="<?= $mob_more_view_cities_li ?> more_view_li col-md-3 col-sm-4 col-xs-6">
				<a href="<?php echo SUB_URL.'/'.$fix_category.'/'.friendly_seo_string($districtResult['place']) ?>" title="<?= $ucw_category.' '.$districtResult['place'] ?>"><?= $districtResult['place'].' ('.$districtResult['num_place'].')'; ?></a>
			</li>
	<?php
		}
	}
?>