Hi Barry! you can do it like this for example:
$query = "SELECT * FROM artist WHERE artist_name LIKE 'b%' ORDER BY artist ASC"; $count = mysql_query("SELECT COUNT(artist) AS count FROM artist WHERE artist_name LIKE 'b%'",$db); $x = mysql_fetch_array($count); $result = mysql_query($query) or die("Select Failed!"); $number = $x["count"]; echo "<h3>Total Number Of Artists In \"B\": "; echo "$number"; 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]; > }}?> "Barry Rumsey" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > 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