if (Yii::app()->request->isAjaxRequest && isset($_GET['term'])&&($keyword=trim($_GET['term']))!=='')
{
$models = Yii::app()->db->createCommand()->selectDistinct('district')
->from('unitlistings')
->where('or like', "district :keyword property :keyword",array(':keyword'=>"$keyword%"))
->order('district asc')
->limit(5)
->queryall();
$suggest=array();
foreach($models as $model) {
$suggest[] = array(
'label'=>$model['district'],
'value'=>$model['district']
);
}
echo CJSON::encode($suggest);
}
I’m gettin error in autocomplete field. How to make this query: select DISTINCT district from unitlistings WHERE disitrct LIKE ‘%keyword%’ or property LIKE ‘%keyword%’