PHP Group BY

<html>
    <head>
    <title>OSTAPENKO FAN CLUB</title>
    </head>
    <body>
<?php


    $db =mysql_connect("localhost","PP30577C","PP30577C") or die ("cant connect");

    mysql_select_db("PP30577C",$db) or die("unable to find database");

    //$duom = mysql_query("SELECT COUNT(post_type) GROUP BY(post_type)");
    $miestai = mysql_query("SELECT post_type, COUNT(post_type) from wp_posts GROUP BY(post_type)");


    echo '<table border="1">';
    while($result = mysql_fetch_array ($miestai)){
        echo '<tr>';
        echo '<td>' . $result[0] . '</td>';
        echo '<td>' . $result[1] . '</td>';
        echo '</tr>';
    }
    echo '</table>';
    mysql_free_result($miestai);
    ?>
    </body>
</html>