query($sql1);
while($row = mysqli_fetch_array($result1)) {
$sql34 = "select * from `new_vendor` LEFT JOIN `vendor_product` ON `new_vendor`.`id` = `vendor_product`.`vendor_id` where `vendor_product`.`xlist`='" . $row['id'] . "' AND `new_vendor`.`status` > '2' AND vendor_product.series_product = 0";
$result34 = $conn->query($sql34);
$rowcount34=mysqli_num_rows($result34);
if($rowcount34 != 0) {
echo '
' . $row['name'] .' ('. $rowcount34 .')';
}
}
//
?>