Dreamweaver Multiple tables

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Arif2010
Forum Newbie
Posts: 1
Joined: Wed Oct 13, 2010 7:44 pm

Dreamweaver Multiple tables

Post 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
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Re: Dreamweaver Multiple tables

Post 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).
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.
wags245
Forum Newbie
Posts: 2
Joined: Wed Oct 13, 2010 2:34 pm

Re: Dreamweaver Multiple tables

Post 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!
Post Reply