query($sql); echo $result->num_rows; ?> Listing in your search.
query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$business_title = $row['Heading'];
$vendor_cat = $row['vendor_cat'];
$sql55_cat = "SELECT * FROM category where id=$vendor_cat";
$result66_cat = $conn->query($sql55_cat);
$row88_cat = $result66_cat->fetch_assoc();
$categoryfor = $row88_cat['categoryfor'];
$cat_title = $row88_cat['title'];
$business_id = $row['id'];
$thumnil_image = $row['thumnil_image'];
$city = $row['city'];
$sql_city = "SELECT * FROM city WHERE mode = '1' AND deleted_at IS NULL and id='$city'";
$result_city = $conn->query($sql_city);
$row_city = $result_city->fetch_assoc();
$title_city = $row_city['title'];
/*city Name*/
$localty = $row['localty'];
/*Gget locaty*/
$sql_localty = "SELECT * FROM sub_category where id='$localty'";
$result_city_local = $conn->query($sql_localty);
$row_city_local = $result_city_local->fetch_assoc();
$localty = $row_city_local['name'];
/* Get Localty*/
$avg_price = $row['avg_price'];
$address = $row['address'];
$vendor_id = $row['id'];
$buss_name_code = $row['buss_name_code'];
?>
30) { // truncate string $stringCut = substr($string, 0, 30); $endPoint = strrpos($stringCut, ' '); //if the string doesn't contain any space then it will cut without word basis. $string = $endPoint? substr($stringCut, 0, $endPoint) : substr($stringCut, 0); $string .= '..'; } echo $string; } else{ echo "Business Address"; } ?>