I want to get all the results from a search but i want to add the results from the same search but with a different filter.
$query_Recordset1 = sprintf("SELECT * FROM animals WHERE %s LIKE '%%%s%%' ORDER BY %s ASC", $filter_Recordset1,$search_Recordset1,$select_Recordset1);
but where %s($filter_Recordset1) id like to have another filter as well...how can i go about doing this?
