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\":&nbsp;&nbsp;";
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

Reply via email to