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/ |
<?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_nationalities_li = $_POST['mob_more_view_nationalities_li'];
$nationalityQuery = mysqli_query($connection,"SELECT COUNT(adv.nationality) as number_of_nationality, adv.nationality, nat.$nationality_column FROM advertise AS adv INNER JOIN nationalities AS nat ON nat.id=adv.nationality WHERE $whereCondition adv.nationality !='' AND adv.adstatus=1 AND adv.isApproved=1 GROUP BY adv.nationality ORDER BY number_of_nationality DESC, nat.$nationality_column ASC");
while($nationalityResult=mysqli_fetch_assoc($nationalityQuery)){
?>
<li class="<?= $mob_more_view_nationalities_li ?> more_view_li col-md-3 col-sm-4 col-xs-6">
<a href="<?php echo SUB_URL.'/'.friendly_seo_string($nationalityResult[$nationality_column]).'-'.$fix_category ?>" title="<?= $ucw_category.' '.$nationalityResult[$nationality_column] ?>"><?= $nationalityResult[$nationality_column].' ('.$nationalityResult['number_of_nationality'].')'; ?></a>
</li>
<?php
}
}
?>