nothing big, but the problem im facing is this. some videos might pertain to a few different genres, and i want to somehow list all these genres in the 'genre' column and have the script search for the keyword in the value. after the if statement im running a loop that displays each result. does this all make sense?? ive tried inserting genres into the same 'genre' column separated by a space, comma...but then it wont find anything unless i search for exactly what the field says. anyone have any ideas on how to fix this one?
$query_Recordset1 = "SELECT id, title, genre, format, image FROM test WHERE $genre=='genre', $genre=='genre2'";
i know this isnt right, but what i want to do here is set up a few (maybe three) genre columns for secondary genres that the video might relate to, in the table. and i want the script to find the results that match from all different genre columns? does this make sense?