hi… i want to create a pagination page with 1 data each page. heres my code.
//controller
$sql = "SELECT COUNT(*) FROM soplusdatafixyii
.somain
soplus
INNER JOIN `opp`.`c_security` opp ON (`soplus`.`UserID`=`opp`.`Emp_Code`)
INNER JOIN `soplusdatafixyii`.`so_detail` `detail` ON (`detail`.`DocNo`=`soplus`.`DocNo`)
WHERE `opp`.`PRFPLUS` = 0 AND `opp`.`Optimal` = 0 AND `opp`.`ServiceCtr` = 0
AND `opp`.`Unison` = 1 ORDER BY `soplus`.`DocNo` ASC";
$numClients = Yii::app()->db->createCommand($sql)->queryScalar();
$pages=new CPagination($numClients);
$pages->pageSize=1;
$sql = "SELECT * FROM soplusdatafixyii
.somain
soplus
INNER JOIN `opp`.`c_security` opp ON (`soplus`.`UserID`=`opp`.`Emp_Code`)
INNER JOIN `soplusdatafixyii`.`so_detail` `detail` ON (`detail`.`DocNo`=`soplus`.`DocNo`)
WHERE `opp`.`PRFPLUS` = 0 AND `opp`.`Optimal` = 0 AND `opp`.`ServiceCtr` = 0
AND `opp`.`Unison` = 1 ORDER BY `soplus`.`DocNo` ASC";
$models=Yii::app()->db->createCommand($sql)->queryAll();
//in my view
<?php foreach($models as $model): ?>
<?php echo $model['id']; ?>
<?php endforeach; ?>
<?php $this->widget(‘CLinkPager’, array(
'pages' => $pages,
)) ?>
but it display me many id… not only 1. please help.