_Problem #1_: How do I simplify my mySql where queries? _Problem #2_: How can I search through an array in my where statement?
Answer: An awesome trick when it comes to querying multiple where clauses is to use the WHERE <…> IN command.
$id = ‘1,4,3,6,8,2’; “SELECT * FROM <…> WHERE id IN ($id)”
Oh and did I mention you can prepend the NOT statement to show results which is NOT included in the list?
$id = ‘5,7’; “SELECT * FROM <…> WHERE id NOT IN ($id)”