pheen

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.

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!