0) { while($row_listdata=mysqli_fetch_array($query_2listcategory)) { $sql2_cat="Select * from `tbl_category` where `status`='1' and `id`='".$row_listdata['cat_id']."';"; $row2_cat = mysqli_fetch_array(mysqli_query($con,$sql2_cat)); $cat_name=$row2_cat['name']; $query_contactinfo=mysqli_fetch_array(mysqli_query($con,"Select * from `tbl_comcontactinfo` WHERE `company_id` ='".$row_listdata['id']."'")); $sql2_city="Select * from `tbl_cities` where `status`='1' and `id`='".$query_contactinfo['city']."';"; $row_city = mysqli_fetch_array(mysqli_query($con,$sql2_city)); $city_name=$row_city['name']; $sql_2localarea="Select * from `tbl_locality` where `status`='1' and `id`='".$query_contactinfo['locality']."';"; $row_2localarea = mysqli_fetch_array(mysqli_query($con,$sql_2localarea)); $locality_name=$row_2localarea['name']; $query_companyimg=mysqli_fetch_array(mysqli_query($con,"Select * from `tbl_companyimg` WHERE `company_id` ='".$row_listdata['id']."'")); $sql_datatime=mysqli_query($con,"Select * from `tbl_comtime` WHERE `company_id` ='".$row_listdata['id']."' and `week_id`='$today_dayid' and `status`='1'"); $query_companytime=mysqli_fetch_array($sql_datatime); if($query_companyimg['type']=='1') { $logos_path=trim($query_companyimg['image']); $supported_image = array('jpg', 'jpeg','png'); $src_file_name = $logos_path; $ext = strtolower(pathinfo($src_file_name, PATHINFO_EXTENSION)); if (in_array($ext, $supported_image)) { $logo_path=$logos_path; } else { $logo_path='empty logo.png'; } } $query_rating = mysqli_query($con,$fdgdfg="SELECT COUNT(*) , AVG(`rating`) as AVGRATE from `tbl_comreview` where `admin_status`='1' and `company_id`='".$row_listdata['id']."'"); $row_rating = mysqli_fetch_array($query_rating); $AVGRATE=$row_rating['AVGRATE']; $numof_rev=$row_rating['COUNT(*)']; $avgrate_rating= substr($AVGRATE,0,3); $view_link=$baseurl.'/edit-details/'.$row_listdata['slug']; ?>
10.02 mi.