Posted by strawberry on 07/12/06 23:42

flamer die.spam@hotmail.com wrote:
> danny_m wrote:
>
> > Hi there
> >
> > I have two tables, pages and sections, of which pages are a subset of
> > sections. I'm listing out the sections in a list and want to include a
> > COUNT of how many pages each section has within it.
> >
> > Pages contain a 'sectionid' field to join it to the 'id' in the seciton
> > table but im unsure how to join, and group to get a count of the
> > number of pages in each section (i.e. in each result row)
> >
> > If anyone can point me in the right direction, id be eternally greatful
> > :-)
>
> not sure if this is what you need exactly, but if your running two
> separate mysql queries on the same page just:
>
> $totalrows = mysql_num_rows($query1)+mysql_num_rows($query2);
>
> Flamer.

the syntax will be along the lines of:

select s.section, sum(p.page) from sections s
left join pages on p.section_id = l.section_id
group by section_id

[Back to original message]