a problem about condition of CDbCriteria

francis · June 8, 2011, 7:41am

I got 4 condition, like A, B, C, D and I want add them by CDbCriteria::addCondition;

how to add them if they got relation like (A AND B) OR (C AND D) ?

thanks for help me

zaccaria · June 8, 2011, 7:49am

Like that:


$criteria->addCondition("(A AND B )");

$criteria->addCondition("(C AND D )", 'OR');

The condition in brackets have to be set toghether.

francis · June 8, 2011, 7:54am

I mean A, B, C, D is a difference condition and each of them need to using CDbCriteria::addCondition to add.

softark · June 8, 2011, 8:37am

You can use CDbCriteria::mergeWith() for that purpose.

francis · June 8, 2011, 9:42am

Aha, thanks for your help, I solved this finally.