I wondering how I can search with multiple criterias independently from each other?
Every file has(id, name.......language, country).
If I enter in my search input fields:
-Country = Spain.
$criteria->compare('language.name', $this->language_search, true); $criteria->compare('country.name', $this->country_search, true);
===>The result will be :all the files from Spain with English language.
But what I need is: all the files from Spain AND all files with English language.
How this could be done?