Counting number of tables in a database

[Schwalbach]

Hey guys,

I am creating a forum, and am gonna put a new table for each forum I create, so whenever I need to know how many forums there are, how can I count the number of tables in a database using a like too

Or:

Count Number_of_tables in database where the table starts with forum?

because I would be naming them:

forum_1
forum_2

etc.

[Imminent]

Hey guys,

I am creating a forum, and am gonna put a new table for each forum I create, so whenever I need to know how many forums there are, how can I count the number of tables in a database using a like too

Or:

Count Number_of_tables in database where the table starts with forum?

because I would be naming them:

forum_1
forum_2

etc.

Are you sure thats the design you want to go for? Why do you need a separate table for each forum and not just add a 'ForumID' field to your thread/post table?

[Schwalbach]

I just wanted to do it that way, was easier. Does it cause a problem with performance or something?

I figured when doing this, it would mean a lot less searching, because if I have say 10 forums and each one has a bunch of posts, then it has to search through all ten of those forums when looking for a post. You know what I mean?

If the counting of tables is impossible, I will just do it that way(the way you suggested)

[Imminent]

But what if a use wanted to search all forums for a topic?

that would mean you'd need to run 10 differenent queries on 10 different tables...

[Schwalbach]

I decided on the one table thing, thanks alot guys