Insert more than recordset in the detail page

Hello everybody i'm creating a website that the users can add some video's, so im stuck in the detailing page i want if a user want to add a video like ''dexter episode 1" and another user want to add the same video "Dexter episode 1 " i don't want to create another detail page i want that the second video go to the first detail page with that i will have a detail page with two recordset i don't know how to do that anyone can help me and thank's :)

so you are trying to create what is called a many to many relationship.


you need to use three tables for this,
*users
*videos
*uservideos

users:
userID - Primary Key
userName
etc....

videos:
videoID - Primary key
videoNmae
etc....

uservideos:
uservideoID - Primary Key
uservideoUserID - creates relationship to the users.userID
uservideoVideoID - creates relationship to vides.videoID

for assigning video to the user, you would need to use the data assist manage relational table behavior.

for displaying videos that relate to the user, you would need to use a joined sql query.

Andrew Reed posted a good thread on using the Manage relational table behavior here:
showpost.php?p=84393&postcount=17

and you can find more details on using join queries here:
sql_join.asp

thank's a lot for the response but if i wan't to add more than one recordset in the detail-page ?

you can add as many recordsets as you like to the details page.

yeah but the detail-page is created to the ID of the recordset i don't know how to fix that can you help me with that please im stuck :( and thank's

the ID being passed in coming from a querystring variable.

look at the recordset that already exists on the detail page for an example of how to use the querystring variable.

Originally Said By: Jason Byrnes

  the ID being passed in coming from a querystring variable.

look at the recordset that already exists on the detail page for an example of how to use the querystring variable.  

Can you explain more ? because i hadn't understand the concept of this S*** x) and thank's

the detail page that is created by the data assist wizard already has a recordset on it.

this recordset is set to filter using a querystring variable that is passed into the page which contains the ID value. this querystring variable is used to return the correct record


your asking how to create another recordset that uses the same record ID, Inspect the existing recordset for an example of how it is done.

May someone help me. Im trying to create a master detail page but i dont want to use a mysql database cause the info to put on the details page is a lot. should i import this data. how do i do all this. Im new to web development, php, mysql.

My master page will have headings with short descriptions, and i want these descriptions to be elaborated with full details on the details page. Each heading on the detail page is a page long data with links, topics and sub-headings and paragraphs.

I just dont want to create plenty of separate pages for each heading i.e; the about us page will have subheadings; our history, our objectives, our mission, our beliefs etc. each of these linked to a single detail page.....im using dreamweaver CS5

To create a Dynamic Master Detail page, you will need to use a mySQL Database to hold the information.

I sugest going through the Database starting kit tutorial:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=104