I'm making a web site (vbscript) with a database (mysql). The site will be used to search for a vehicle. So there will be a lot of records in the database. There will be a users table in the DB for registered users to use special features of the site.

I want to make a message board from scratch but I don't know if I should add the tables for the message board to my existing database or create a separate database just for the message board and store the user ID in the message board DB.

What do you think I should do?


Thanks

___________________
redtag | auto
www.redtagauto.com

I would create a message table in the existing database and as you say, link to the usertable by having the user_id in the message table.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

So basically you think that I should have 1 big database and that's it?

Do you think you can tell me why you think that method is better? (so I can learn)

Thanks.

___________________
redtag | auto
www.redtagauto.com