Forums

This topic is locked

Any thoughts on databasedesign

Posted 25 Apr 2001 16:27:25
1
has voted
25 Apr 2001 16:27:25 Adil Gunaslan posted:
Hi all and especially Waldo who helped me alot already,

I saw the presentation UDzone gave on UCON here and see from the database design that all the content basically comes from one table.
I'm wondering how one would go about when using a dynamic navigation table interacting with more than one table for the actual content.
For example: Presenting newsitems (one table) and a membersdirectory(another table with different fields) all embedded in a single ASP page and using URL parameters to get the content from the correct table. Is this possible and how?

thanx in advance
Adil

Replies

Replied 29 Apr 2001 18:06:54
29 Apr 2001 18:06:54 sam am replied:
use the inner join method, but ensure you have a unique identifier in each table.

Reply to this topic