Select all tables within a table

[Moshambi]

Hello,

I have a database for an events calendar that is setup like this:

events
---->september2009
---->october2009
---->november2009
etc. etc.

I am trying to make a backend CMS for the owner using PHP. What I want to be able to do is list all of the events by the month. So:

September
Events here.

October
Events here.

November
Events here.

Now, I know how to display the events of each table, that's easy. But I do not know how I can select all of the tables inside of the events table without manually inserting each table name into the SQL statement.

Does this make sense? Is this possible?

Would love to learn how to do this and many thanks to anyone that can help me out with this.

Mosh

[james438]

Moshambi, I am not sure what you mean. Do you want to select all the results from the table September 2009? type show columns from tablename. I need more details on how your table is set up. What does the query look like for inserting data into your table?

pakhodn, I am unfamiliar with mircosoft excel object. Is that an addon for php? Could you post a link so that I can learn more about it?