MySQL Question

[Anon]

Hi there.

I have this following problem.
I'm building a forum, whith multiple forums support (& some more features).
I have created one table for the entire forum.
But now I want it to display the total posts with as little querys as possible (like: 1 query).
Also the inserting of a post should not take more than 3 querys.
Can someone help me out?

Thx,
DanceTrend.

[Anon]

Normally you'd have one table for each forum, not one for all forums.

Inserting a new post should be a one-query operation as all the information you need should have been retreived while the user was surfing to the post that he wants to reply to.

If you don't have a fancy post-reply structure (ie: no threads) then getting all articles is also a one-query thing.

[Anon]

Yesyes I know...
but....never mind....
I'll do your way: One table for each forum.
Should be ok too.

[Anon]

There are so many great forum scripts out there-- some even in PHP. Why are you trying to reinvent the wheel?

-- Jennifer

  Have crazy client stories to tell?  Post them at
                DUMBCLIENTS.COM

[Anon]

Uhhhhhhhhh...