HI, I have a problem.
I dont know how to create tables for this in PHPMYADMIN, the situation is like this: I have to display lot of items on the screen. There are three Datagrids on the screen (I am using Flash for this so if i get the database structure right, i will be able to take care of the rest of the scripting to returning data from database.). Lets say the three DataGrids are called: DG1, DG2 and DG3 DG1 displays the list of CONTINENTS like (Norht America, Asia, South America, Australia etc.) If you click any region in DG1, DG2 gets populated with list of countries (like USA, Canada, Mexico... etc.) At the same time, when i have clicked a CONTINENT in DG1, an image of the CONTINENT is displayed on the screen. Now, If i click on any Country in DG2, DG3 is getting populated with a ist of Clubs (like Club1, Club2, Club3 etc.) At the same time, An image of the country and a description of the country are displayed on the screen. again, if i click on any CLUB, it displays a Image, description and URL of the CLUB. I dont know what the DATABASE STRUCTURE shold look like for this. I know there has to be some kind of LINKING between the tables but i dont know HOW..... :( I have been trying few things but without any success :( ------------------------------------------------------- The DG1 field will be: Continent_Name | Continent_Image | Continent_Text The DG2 fields will be: Country_Name | Country_Image | Country_Text The DG3 fields will be: Club_Name | Club_Image | Club_Text | Club_Url ------------------------------------------------------- Can anyone show me the Sql for such a table structure? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
