MySQL help

new to databases

[Mr_Cat]

Hi folks,

I'm new to databases and mysql, I have set up a site and some free forum software on it, which has used up the one database that I get with my server package.

What I want to do is try and add some more interactive pages and features, such as perhaps a links page where people could put their own links into a form and update the page etc. I guess I would need another database for each of such features, or can I somehow use the one I've got. Or am I thinking along the wrong lines altogether?

Any help would be great
Cheers

[phranque]

welcome to WebmasterWorld [webmasterworld.com], Mr_Cat!

you can add more tables to your existing database to support the additional features.

[physics]

Mr_Cat - often what people do in this situation is to prefix the new table names. So, for your forum you would install it with a "forum_" prefix, so the tables would look like
forum_posts
forum_stats
...

Then you can install a blog, say Wordpress, and it can use the prefix "wp_".

And you can add your own custom features and use the prefix "custom_" or whatever.

Having separate database is preferable but if you don't have the resources ...

[Mr_Cat]

Great! Thanks very much :D

I'll try that out. I want some sort of feature for users to write articles and stuff for the site, I think wordpress might do it.

Cheers for the advice! It's a charity number so resources are bog all but I might be able to get an extra database out of my server people soon.