$sql = "SELECT * From codeinventory ORDER by id ASC LIMIT $offset, $rowsPerPage";
//$sql = "Select id, DateRequested, RequestedBy, ApprovedBy, centre From overtime";
//$sql = "Select count(prRef) as countPrRef, prRef, count(prOrderDate) as countprOrderDate, prProcessStatus, prOrderDate, prPRFNo, prPreUserID, prReqUserID, prReqDate, prVerUserID, prVerDate, prAppUserID, prAppUserID2 From pr Group By prRef Order By prOrderDate DESC, prPRFNo, prPreDate DESC ";
//$sql = "Select * From pr";
$No = $offset + 1;
$rs = mysql_query($sql) or die(mysql_error());
if ($rs)
{
while ($rw = mysql_fetch_object($rs))
{
$id=$rw->id;
$code=$rw->code;
$name=$rw->name;
$category=$rw->category;
?>