Question

I have to tables, one is profile and the other is rating. rating has a field profileid which is primary key to profile.id and a field with rating values. Now I want to find the field with highest rating and display the corresponding profile. Since I m new to YII framework I m having troubles with it. Please help me getting out of it. What I m doing is described below.

$topRage=new CDbCriteria();
$topRage->select="*";
$topRage->alias="t1";
$topRage->order="rateing DESC";
$topRage->join="JOIN `ratings` ON `profile`.`id` = `t1`.`profileId`";
$topRage->limit="1";

Answer 1

引证:

join= JOIN profile ON profile.id = t1.profileId ;

如果你这样做的话:Ratings:model()->findAll($Rage),那么评级表已经问,因此,你需要加入简介表。

<><>Edit>:

你们需要这样做:

$echo "Rating id: ".$rating->id."|&nbspProfile Id: ".$rating->profile->id."|&nbspProfile Name: ".$rating->profile->name."|&nbspRating: ".$rating->ratingvalue;

http://www.un.org/Depts/DGACM/index_french.htm

也可使用<代码>find($topRage)而不是findAll($topRage),删除limit,但这只是采取另一种做法。

Answer 2

just query without join .

$topRage=new CDbCriteria();
$topRage->select="*";
$topRage->alias="t1";
$topRage->order="rateing DESC";
$topRage->limit="1";

$rating=Ratings::model()->findAll($topRage);
$profile=Profile::model()->findByPk($rating->profileId);

友情链接