Implement Query

Yii 1.1 General Discussion
1

I have a code

model:

public function MinIpkReguler($i) {

     $criteria=new CDbCriteria;


        $criteria->alias='m';


        $criteria->select='min(m.ipk) as MinIpk'; 


        $criteria->join='JOIN status_mahasiswa_s1 s ON (m.id=s.id)';


        $criteria->addCondition('s.status="reguler"');


         if ($i == 0) {


        $criteria->addCondition('m.tahun_akademik_lulus = YEAR(CURDATE())');


        $MinIpkR=  MahasiswaS1::model()->find($criteria);


    } else if ($i == 1) {


        $criteria->addCondition('m.tahun_akademik_lulus = YEAR(CURDATE())-1');


        $MinIpkR=  MahasiswaS1::model()->find($criteria);


    } else if ($i == 2) {


        $criteria->addCondition('m.tahun_akademik_lulus = YEAR(CURDATE())-2');


        $MinIpkR=  MahasiswaS1::model()->find($criteria);


    } else if ($i == 3) {


        $criteria->addCondition('m.tahun_akademik_lulus = YEAR(CURDATE())-3');


        $MinIpkR=  MahasiswaS1::model()->find($criteria);


    } else if ($i == 4) {


        $criteria->addCondition('m.tahun_akademik_lulus = YEAR(CURDATE())-4');


        $MinIpkR=  MahasiswaS1::model()->find($criteria);


    }


    return $MinIpkR;


}

controller:

$MinIpkR0= MahasiswaS1::model()->MinIpkReguler(0);

$this->render(‘tabel311’,array(‘MinIpkR0’=>$MinIpkR0))

view:

<?php if($MinIpkR0 != NULL) echo $MinIpkR0->MinIpk; else echo 0 ?>

ive got problems.. it didnt show any error, but it didnt show the value too,, whats wrong with my code???

2

Try to debug with firebug in firefox you may get some error or bug ::)

and where is your else part? first put else part and print something inside and check what’s happening with your code…