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
Dreamweaver Multiple tables
Moderator: General Moderators
Re: Dreamweaver Multiple tables
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).
It would just be a select, with a loop, using an identifier for the table (using $_GET).
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
Re: Dreamweaver Multiple tables
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!
really i having a bad time of how to use the list/menu
can't make search a database using that!