On Sunday 10 February 2002 00:55, Barry Rumsey wrote:
> I have the following code:
> $query = "SELECT * FROM artist WHERE artist LIKE 'b%' ORDER BY artist
> ASC";
[snip]
> What I would like to know is how do I do a count on each result
> returned.e.g. Benny(4) , Bill(10)
Try:
$query = "SELECT artist, count(artist) FROM artist WHERE artist LIKE 'b%'
ORDER BY artist ASC";
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Love is being stupid together.
-- Paul Valery
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
