Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Creating Multiple Databases or Not??

Quote Reply
Creating Multiple Databases or Not??
Hi All,

Im creating an online guide and this is how it will work.

Main Categories are a list of all major UK Towns. so people can access their town by typing http://domain.com/yourtown

Then under each town I need various categories, ie clubs, organisations etc. under each of these will be a links of businesses under the various categories. then links to a detailed page for each.

Also each category would have to gather different information on the business to be displayed?

How would i go about doing this with LinksSQL? would I have to use seperate databased?





Regards

MDJ1
http://www.isee-multimedia.co.uk
Quote Reply
Re: Creating Multiple Databases or Not?? In reply to
Nope...I would keep all the tables in the same database since Alex already mentioned in the forums in terms of the number of connections, they multiple across different database. Also, multiple databases has been discussed in this forum and in the Pre Sales Forum...Wink

Basically, all you have to do is like what you did with LINKS 2.0, which is to create categories and subcategories. Detailed pages are already built-in, so that is not a problem.

Good luck!

Regards,

Eliot Lee Wink
http://anthrotech.com/
Quote Reply
Re: Creating Multiple Databases or Not?? In reply to
Thanks Eliot, but how would I go about creating new tables for different businesses?

or maybe it would be easier to create a large table full of all the information, then only show / allow the user to add to certain fields depending on the category they want to add their business too.

Regards

MDJ1
http://www.isee-multimedia.co.uk