I am not aware of linked tables too much, is this what is called linked table?
Do i have to enter values on both tables to link them? Or can some columns of one table be linked with columns of another table in some other way? If no, then thanks for all who helped me :) --sajid "Adam Bregenzer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
