Click here to Skip to main content
15,891,184 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
my question on mysql how to insert multiple songs with single movie ,,if i click on that movie only that songs will display ..
Posted
Comments
CHill60 2-Jul-14 11:31am    
Not clear. Post the code that you have tried so far.

1 solution

This is basic referential database construction - I assume you're very new at this.

First, put the movies in their own table (without the songs), and have an IDENTITY field in the table (look that up if you don't know what it is!). You may have other data fields, but the main important concept is that the movies are stored independently of the music and they each have a unique reference.

Second, create a table for your music. It must have at least two fields. One field, of course, is the music. The second field is a reference value equal to the unique IDENTITY value for the related movie.

Now, when you pick a movie, you can request it's identity. With the identity, you can request its unique music list.


 
Share this answer
 
Comments
Matt T Heffron 2-Jul-14 19:26pm    
+5

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900