Page 1 of 1

Dreamweaver Multiple tables

Posted: Wed Oct 13, 2010 11:20 pm
by Arif2010
sry i mistakenly pressed Ctrl+S


so here is the question again. i have multiple tables in a database. but one table is simply the table of the other tables. here is what i mean:



TABLE 1 _ TournamentsList
---------------------------------------------------------------------- -------------
TourneyID: | TournamentName | StartDate
---------------------------------------------------------------------- ------------
01 | Tourney1 | 1 Jan 2011
02 | Tourney2 | 1 Feb 2011
03 | Tourney3 | 1 Mar 2011

The rest of the tables are talbes for each entry into the above table



TABLE 2 _ Tourney 1
---------------------------------------------------------------------- -------
PlayerID: | Name | RegistrationDate
---------------------------------------------------------------------- -------
01 | Tom | 1 Jan 2011
02 | Dick | 1 Feb 2011
03 | Harry | 1 Mar 2011

TABLE 3 _ Tourney 2
---------------------------------------------------------------------- -------
PlayerID: | Name | RegistrationDate
---------------------------------------------------------------------- -------
01 | Tom | 1 Jan 2011
02 | Dick | 1 Feb 2011
03 | Harry | 1 Mar 2011

TABLE 4 _ Tourney 3
---------------------------------------------------------------------- -------
PlayerID: | Name | RegistrationDate
---------------------------------------------------------------------- -------
01 | Tom | 1 Jan 2011
02 | Dick | 1 Feb 2011
03 | Harry | 1 Mar 2011

Now i want to create two, and only two, pages in dreamweaver. the first page displays TABLE 1. But the second page displays either Table 2, 3, or 4 depending on which is selected from page 1. One option is to create a separate page for each table. but that will become unmanagable as there are further filtering applied to each table. Also there are over 10 entries in Table 1, i.e. over 10 tournaments. My question is basically how do i create the second page so that it dynamically extracts data from the database and display table2, 3 or 4 depending on which is passed to it.

Thanx for your help

Re: Dreamweaver Multiple tables

Posted: Thu Oct 14, 2010 12:54 am
by s.dot
Are you familiar with basic database usage in PHP?

It would just be a select, with a loop, using an identifier for the table (using $_GET).

Re: Dreamweaver Multiple tables

Posted: Mon Oct 18, 2010 12:22 pm
by wags245
can i ask question how can i use the select?
really i having a bad time of how to use the list/menu
can't make search a database using that!