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_adservices_li = $_POST['mob_more_view_adservices_li'];
$adserviceQuery = mysqli_query($connection,"SELECT ad_serv.adservice_id, adserv.$adservice_column, count(ad_serv.id) AS adservice_ads_count FROM ads_adservices AS ad_serv INNER JOIN advertise as adv ON adv.id = ad_serv.ad_id INNER JOIN adservices as adserv ON adserv.id = ad_serv.adservice_id WHERE $whereCondition adv.adstatus=1 AND adv.isApproved=1 GROUP BY ad_serv.adservice_id ORDER BY adservice_ads_count DESC, adserv.$adservice_column");
while($adserviceResult=mysqli_fetch_assoc($adserviceQuery)){
?>
<li class="<?= $mob_more_view_adservices_li ?> more_view_li col-md-3 col-sm-4 col-xs-6">
<a href="<?php echo SUB_URL.'/'.friendly_seo_string($adserviceResult[$adservice_column]).'/'.$fix_category ?>" title="<?= $adserviceResult[$adservice_column].' '.$ucw_category ?>"><?= $adserviceResult[$adservice_column].' ('.$adserviceResult['adservice_ads_count'].')' ?></a>
</li>
<?php
}
}
?>