USe the count() function in mysql. 
Like this:

 $query = "SELECT count(artist) as howmany FROM artist
WHERE artist LIKE
 'b%' GROUP BY artist 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] ($howmany)";
 }}?>


olinux

> 
> What I would like to know is how do I do a count on
> each result 
> returned.e.g. Benny(4) , Bill(10)
> 


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to