I am building a personal movie database. I've scraped my info from imdb with my pictures, ratings, year, yada yada. But my filter needs some tweaking/help. I can only seem to filter one word in my genre column.
I want to be able to show all records that contain the word Action (i.e. %Action%).
Right now it's returning the records where the only word in the column is Action.
The way the mysql column is setup, it has data in it like "Action, Drama, Thriller" or "Comedy, Drama, Romance" or "Action, Adventure". Currently, my filter is skipping these genre records and returning the ones that have just "Action".
I was hoping to find a way to tweak my filters.php which fills up my drop down menu in my filter form. I've tried a bunch of basic tweaks to try and allow any record with the word Action, or any record with the word Drama to no avail:
"Action" => "%Action%",
"Action" => "*Action*",
etc.
Here is my filters.php page.
$genres = array(
"Action" => "Action",
"Adventure" => "Adventure",
"Animatin" => "Animatin",
"Biography" => "Biography",
"Comedy" => "Comedy",
"Crime" => "Crime",
"Documentary" => "Documentary",
"Drama" => "Drama",
"Family" => "Family",
"Fantasy" => "Fantasy",
"Fil-Noir" => "Fil-Noir",
"History" => "History",
"Horror" => "Horror",
"Music" => "Music",
"Musical" => "Musical",
"Mystery" => "Mystery",
"Romance" => "Romance",
"Sci-Fi" => "Sci-Fi",
"Sport" => "Sport",
"Thriller" => "Thriller",
"War" => "War",
"Western" => "Western");
Any help would be greatly appreciated as this is the last thing I need to do to complete the project.
Jerome