How to structure this MySQL data?
View Single Post
09-20-2009, 07:41 PM
Join Date: Apr 2008
Location: Nevada, USA
Ahh yes, I already have the movie table taken care of. And yes, the parent series would be according to the tv_id. But I have another question, because each series is going to have different amounts of episodes, how will I deal with the amount of columns I am going to need for each show. Oh crap, I just remembered that it will need to be sorted by season as well. So 'Tv_show > Season > Episode.'
Ok, but mainly how do I deal with the amount of columns that I will be needing? because not every show is going to have the same amount of episodes. Should I just be leaving the extra ones blank?
View Public Profile
Send a private message to h0ly lag
Visit h0ly lag's homepage!
Find More Posts by h0ly lag