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