使用yii框架从内部联接的数据库中选择显示值

Question

I cant display value in repeated column names with inner join of two tables using yii. my view page is advance_search_detail.php and controller sitecontroller.php.I got the error 'Property "Job.Ltitle" is not defined'.

Controller is sitecontroller.php

public function actionadvance_search_result()
{
$title=$_GET['title'];
$experience=$_GET['experience'];
$location=$_GET['location'];
$category=$_GET['category'];
$salary_min=$_GET['salary_min'];
$salary_max=$_GET['salary_max'];

$criteria = new CDbCriteria();
$criteria->select = 't.title, location.title as  Ltitle,  t.key_skills, t.description, t.no_vacancy, t.experience, t.company_name, t.salary';
$criteria->join = 'INNER JOIN location ON t.location_id = location.id';
if($experience!="")
{
$criteria->addCondition("(title like '%$title%' or  key_skills like '%$title%') and   (experience like '%$experience%')");    
}
if($location!="")
{
   $criteria->addCondition("location_id like '%$location%'");
}

if($category!="")
{
   $criteria->addCondition("category_id like '%$category%'");
}
if($salary_min!="" && $salary_max!="")
    {
        $criteria->addCondition("salary >= '$salary_min' and salary <= '$salary_max'");
    }

$count=Job::model()->count($criteria);
$pages=new CPagination($count);
$pages->pageSize=2;
$pages->applyLimit($criteria);
$model=Job::model()->findAll($criteria);
$number_rec=count($model);
if($number_rec<=0)
{
  $this->render('search_result1',array('model' =>$model));
}
else
{
  $this->render('advance_search_result',array('model' =>$model,'pages' => $pages));
}

}

My view page is advance_search_result.php

<div>
<div>
<h1>Search Results</h1>
<ul style="list-style:none; ">
<?php
  foreach($model as $models)  
  {
    $job_id=$models->id;
  ?>
   <li><p><?php //echo $models->title; ?>
      <?php echo CHtml::link($models->title, array('site/advance_search_detail', 'job_id'=>$job_id,'status'=>0)); ?></p>
      <p><?php echo CHtml::link($models->Ltitle); ?></p>
      <p><?php echo $models->company_name; ?></p>
      <p><?php echo $models->description; ?></p>
      <p>Keyskill:<?php echo $models->key_skills; ?><p>
  </li></br>
<?php
  }
 ?>
</ul>    
<p><?php $this->widget('CLinkPager', array('pages' => $pages)) ?></p>   

Anybody help me?

Answer 1

Check Your two model relation first and then set alias to location table. Table Job has alias (t) and set table location alias (l). Like below

$criteria = new CDbCriteria();
$criteria->select = 't.title, l.title as  Ltitle,  t.key_skills, t.description, 
t.no_vacancy, t.experience,   t.company_name, t.salary';

$criteria->join = 'INNER JOIN location l ON t.location_id = l.id';