0) { $row_category=mysqli_fetch_array($query_category); $category_id = $row_category['id']; if($row_category['cat_id']!='0'){ $row_mcategory=mysqli_fetch_array(mysqli_query($con,'select * from `tbl_category` where aproval_status="1" and `id`="'.$row_category['cat_id'].'"')); $main_catid=$row_mcategory['id']; } else { $main_catid=$category_id; } $sql_city="Select * from `tbl_cities` where `status`='1' and FIND_IN_SET(`name`,'$local_area');"; $query_city=mysqli_query($con,$sql_city); if(mysqli_num_rows($query_city)>0) { $row_city = mysqli_fetch_array($query_city); $city_id.=$row_city['id'].','; } $sql_localarea="Select * from `tbl_locality` where `status`='1' and FIND_IN_SET(`name`,'$local_area');"; $query_localarea=mysqli_query($con,$sql_localarea); if(mysqli_num_rows($query_localarea)>0) { $row_localarea = mysqli_fetch_array($query_localarea); $locality_id.=$row_localarea['id']; } echo $city_id = rtrim($city_id,','); echo $locality_id =rtrim($locality_id,','); if($city_id>0){ $city_sql =" AND `tbl_comcontactinfo`.`city`='$city_id' "; } if($locality_id>0){ $sql_locality="ORDER by `tbl_comcontactinfo`.`locality`='855' DESC"; } } else { echo 'not found!'; exit; } if(!empty($locality_id) || $locality_id>0) { $address_title=$row_localarea['name'].' - '.$row_city['name']; } else { $address_title=$row_city['name']; } $title=$row_category['name'].' in '.$address_title.' | '.ucfirst($domin_name).''; $keywords=''; $description=''; include('includes/header.php'); ?>

Results in ,

0) { ?>

'; $time_h=$time_h.':00'; $query_starttime=mysqli_fetch_array(mysqli_query($con,"Select * from `tbl_time` WHERE `time` ='$time_h'")); $current_timeid=$query_starttime['id']; $start_time = $query_companytime['start_time']; $end_time = $query_companytime['end_time']; '
'; if($start_time<=$current_timeid && $current_timeid<=$end_time) { $time_title='Open now'; } else { $time_title='Close now'; } } else { $time_title='24/7 Open'; } } else { $time_title='Close now'; } $query_comgallery=mysqli_fetch_array(mysqli_query($con,"Select * from `tbl_comgallery` WHERE `company_id` ='".$row_listdata['id']."'")); $distance_sql=mysqli_fetch_array(mysqli_query($con,"SELECT `latitude`, `longitude`, SQRT(POW(69.1 * (`latitude` - 28.6754857), 2) + POW(69.1 * (77.2876161 - `longitude`) * COS(`latitude` / 57.3), 2)) AS distance FROM `tbl_comcontactinfo` WHERE `id`='".$query_contactinfo['id']."'")); $view_link=$baseurl.'/'.$row_city['slug'].'/'.$row_2localarea['slug'].'/'.$row2_cat['slug'].'/'.$row_listdata['slug'].'/'; ?>

0.0

KM

Result not found !

'; } ?>

© 2021 Nearlyplace. All rights reserved.