I have the following code: $query = "SELECT * FROM artist WHERE artist LIKE 'b%' ORDER BY artist ASC"; $result = mysql_query($query) or die("Select Failed!"); echo "<h3>Total Number Of Artists In \"B\": "; echo mysql_num_rows($result); echo "<br><br></h3>"; if (mysql_num_rows($result)) { echo "<table>"; echo "<tr><th>Artists</th>"; while ($qry = mysql_fetch_array($result)){ echo "<tr>"; echo "<td>"; echo $qry[artist]; }}?>
What I would like to know is how do I do a count on each result returned.e.g. Benny(4) , Bill(10) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php