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
