Ok, so I am making a script for one of my friends. He is creating lists of movies with their info, such as the poster, a description of the movie, etc... I got this working fine. But he is also listing TV shows with the same generic information. What it's about etc.. Then he has links to each episode. Now my question is, how do I organize the tables in the database to be able to add the episodes to the TV show series, and then bring all this together and be able to have each episode become a clickable link when I put the page together that will read from the database?


This is what I'm thinking:

-Database

--tv
---ID
---series title
---Description

--episodes
---ID
---parent series
---episode name
---description
---more fields, etc..

__________________