results multiple filter database
Here's an easy one (I hope!). On my product results page, I'm filtering by product category. I would like to be able to filter more that one category.
Right now, I have;
$query_rsProducts = "SELECT productID, ItemNum, ItemName, thumb FROM toys WHERE categoryID = 1 ORDER BY indexDate DESC";
where I'm getting all products with categoryID 1.
However, I would like to get both 1 and 3, etc. I tried using an AND clause, but that didn't work.