view controller part 1

    public function actionView($id)
    {
        $SQL="SELECT * FROM bp_produk WHERE kategori_produk_id='".$id."'";
        $commands=Yii::app()->db->createCommand($SQL);
        $models=$commands->queryAll();

        $this->render('view',array(
            'model'=>$this->loadModel($id),'models'=>$models
        ));
    }