Answer the question
In order to leave comments, you need to log in
Mysqli: how to make a limit select for a pair of IN values?
There is a table contacts
with fields id|city_id|category_id|email
Now the query is:
"SELECT (id,email) FROM contacts WHERE city_id IN (".implode(',', $arrCity).") AND category_id IN (".implode(',', $arrCategory).")"
Answer the question
In order to leave comments, you need to log in
I agree with Rsa97, make 2 requests with limits, and unite them with UNION.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question