var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Count the number of items for a query
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
and instead it should be
id title band url letter
id title url count
Last edited by s0me0ne; 01-10-10 at 15:32.
I figured it out, I needed to add " GROUP by g.letter" to the end