Multiple Condition In Criteria

Yii 1.1 General Discussion
1

Hi this is my sql query

$sql=select t.user_id,t.username,c.name,s.name from user as t

				left join country as c on t.contry=c.id


				left join state as s on t.state=s.id where t.user_id=$userid or t.username=$username or c.id=$countryid

above query i have wrote in normal sql statement but i need above query convert into compare statement in yii.

plz any one help me.

2

use findall(array(‘join’=>‘your-condition’,‘condition’=>‘t.user_id=:userid or t.username=:username or c.id=:countryid’,‘params’=>array(’:userid’=>$userid,…)))

3

Example




$campaigns=Campaign::model()->findAll(array('join' => 'JOIN business_profile ON profile_id = business_profile.id',

'condition'=>'business_profile.user_id=:id',

'params' => array(':id'=>Yii::app()->user->id)));
4

Hi rajith,

Thanks for your help

5

:)

got it?