RTJ
(Jenea Njs)
January 15, 2013, 7:31pm
1
how to combine two queries to the database?
I need to join these two queries into one:
$a=DB::model()->findAll($criteria);
$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.
RTJ
(Jenea Njs)
January 15, 2013, 7:42pm
3
I need to order the first query and the second query to display the results after the first.
Some example?