Count the number of items for a query

s0me0ne · #1 (**permalink**) 01-10-10, 14:57

I'm trying to output how many bands I have for a genre starting with a certain letter using this query

SELECT p.title AS title, g.letter AS letter, g.url AS url
FROM band AS g, genre AS p
WHERE g.genre = p.id AND p.url='" . $clean['genre'] . "'"

However I'm getting

HTML Code:

0-9 ()
0-9 ()
0-9 ()
0-9 ()
B ()
B ()
B ()
...

and instead it should be

HTML Code:

0-9 (4)
B(3)
...

Bands table:
id title band url letter

Genre table:
id title url count

s0me0ne · #2 (**permalink**) 01-10-10, 15:50

I figured it out, I needed to add " GROUP by g.letter" to the end

Internet Services

Web Development

Digital Marketing

Consumer Tech