Q: How to count mysql with using group by PHP? How to count mysql with using group by PHP ?
When i test this code it's echo 1
How to do for echo 3 (by count country)?
This is my table_test
_____________________
|__id___|__country__|
|__1____|____usa____|
|__2____|____usa____|
|__3____|___china___|
|__4____|____uk_____|

This is my code.
<?PHP
$result = mysql_query("SELECT COUNT(*) FROM table_test GROUP BY country");
$row = mysql_fetch_row($result);
mysql_free_result($result);
$all_country = $row[0];
echo $all_country;
?>


A: Try:
SELECT Country,COUNT(*) FROM table_test GROUP BY country


A: 1) Use mysqli_* API instead of mysql_* API
2) Use mysqli_num_rows to get total row returned
$sql="SELECT COUNT(*) FROM table_test GROUP BY country";

 if ($result=mysqli_query($con,$sql))
 {
    $rowcount=mysqli_num_rows($result);
 }

echo $rowcount; // print 3


A: use this code for counting rows of selected query
 <?php
$result = mysql_query("SELECT COUNT(*) FROM table_test GROUP BY country");
$row = mysql_fetch_row($result);
$all_country = mysql_num_rows($result);
echo $all_country;
?>

