display empty count result

Hi

i have this code..how do i display empty count result ?

Code:

---

<?php
// Make a MySQL Connection

$query = "SELECT type, COUNT(name) FROM products GROUP BY type";
       
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
        echo "There are ". $row['COUNT(name)'] ." ". $row['type'] ." items.";
        echo "<br />";
}
?>

---

Code:

---

<?php
// Make a MySQL Connection

$query = "SELECT type, COUNT(name) as count FROM products GROUP BY type";
       
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
        echo "There are ". $row['count'] ." ". $row['type'] ." items.";
        echo "<br />";
}

---

Quote:

---

Originally Posted by jan127

Code:

---

<?php
// Make a MySQL Connection

$query = "SELECT type, COUNT(name) as count FROM products GROUP BY type";
       
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
        echo "There are ". $row['count'] ." ". $row['type'] ." items.";
        echo "<br />";
}

---

---

it's ok, thanks jan127

Using this code you can display empty count result:

Code:

---

$total_rows = mysql_num_rows($result);
if($total_rows>0){
// please use your code in this section


}
<?php
// Make a MySQL Connection

$query = "SELECT type, COUNT(name) FROM products GROUP BY type";
 
$result = mysql_query($query) or die(mysql_error());
$total_rows = mysql_num_rows($result);
if($total_rows>0){
// Print out result
while($row = mysql_fetch_array($result)){
 echo "There are ". $row['COUNT(name)'] ." ". $row['type'] ." items.";
 echo "<br />";
}
}

?>

---