how to combine two queries to the database?
I need to join these two queries into one:
$b=DB:model()->findAll("a = 0");
php version is 5.2.17
and now need to join in a single queries $c to be sent to pager.
How I can do this?
thank you very much in advance
Read some more about CDbCriteria and you will find out that it’s easy to add ‘a = 0’ to the search criteria as the where clause or by using addColumnCondition.
I need to order the first query and the second query to display the results after the first.