$sql_listcategory="SELECT * FROM `tbl_directory` WHERE `tbl_directory`.`user_id`='$user_id'";
$sql_listcategory;
$query_2listcategory=mysqli_query($con,$sql_listcategory);
$row_datac=mysqli_num_rows($query_2listcategory);
if($row_datac>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']; ?>
} } ?>