pheen Posted June 20, 2009 Share Posted June 20, 2009 Hi! So basically, I have a table storing information about movies, name, genre, etc.. I'm having trouble figuring out how to handle movies with multiple genres. I'm not even sure how to word what im looking for, so I haven't been able to find very useful information. I thought I was on the right path creating a second table with all the genres in it, but then I was stuck when figuring out how to join multiple genres to a single row or movie. If anyone is able provide an answer or even point me in the right direction it would be greatly appreciated! Link to comment https://forums.phpfreaks.com/topic/163000-solved-join-question/ Share on other sites More sharing options...
pheen Posted June 20, 2009 Author Share Posted June 20, 2009 Figured it out. Entering the genres into a text field and searching it with the LIKE command in my query should allow me to do what I've been trying to do. Link to comment https://forums.phpfreaks.com/topic/163000-solved-join-question/#findComment-860321 Share on other sites More sharing options...
gassaz Posted June 20, 2009 Share Posted June 20, 2009 The best optios for me is store de genres in a design like this.. [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/163000-solved-join-question/#findComment-860324 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.