On Tue, 2004-02-10 at 09:49, Sajid wrote: > > A way you could do this, is to set up the tables like this: > > > > DG1: > > Continent_Id | Continent_Name | Continent_Image | Continent_Text > > > > DG2: Country_Id | Continent_Id | Country_Name | Country_Image | > Country_Text > > > > DG3: Club_Id | Country_Id | Club_Name | Club_Image | Club_Text | Club_Url > > Thanks for your help. > But what i feel is that this is a more tedious process to achieve what i > want to. > What will happen in this is that i have to enter proper Continent ID and > Country ID in both Country and Club tables respectively. > For that i have to go and check that these ID's are in the other tables. > > I was looking for something to do with Linked Tables. > Can anyone show me an example of how this can be done using Linked Tables?
You can write an admin interface to manage adding the rows to your tables if you don't want to do it manually. This seems like as close to a linked list as you are going to get: each item in the child table has a link (id column) to it's parent. You reference that to find children/parents. This is generally the way relational databases are structured. Maybe if you expand on what you mean by a linked list we can provide a different answer. -- Adam Bregenzer [EMAIL PROTECTED] http://adam.bregenzer.net/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
