Posted by Bonge Boo! on 09/09/05 14:00

I'm not sure if I'm going about this the sensible way for not, so...

I have 2 tables. Once contains details of various events. Name of the event,
when it starts, how many days and a primary key.

Another table has the names of people going to the events, and a key that
corresponds to an event in the first table.

I want to write a query that will produce a recordset that has the name of
the event and the number of people attending it.

So basically name of event, then count(query to find people attending event
x)

I could do this in PHP by created a nested sql query, then use array push to
add that data into a bigger array, then output that. Which is what I've
done. But I was hoping to be able to write an SQL query so I could then use
the ADODB function to output to a CSV file.

Is it possible to write an SQL query to do what I've tried to explain above,
or should I just stick with PHP and write the functions to export as CSV.

Any suggestions? My MYSQL query skills are limited, but I'm trying to expand
them. This seemed a good place to start.

[Back to original message]