display empty count result

[mulaus]

Hi

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


<?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 />";
}
?>

[jan127]

<?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 />";
}

[luattrihung11]

<?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

[deemtech]

Using this code you can display empty count result:

$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 />";
}
}

?>