Smarty

[Ee]

SmartyPaginate-1.2
ADODB Library for PHP4

// Pagination
require('./includes/smarty/SmartyPaginate.class.php');

// required connect
SmartyPaginate::connect();
// set items per page
SmartyPaginate::setLimit(10);

$sql = "SELECT users.*,jawatan.jawatan FROM users,jawatan WHERE users.id_jawatan = jawatan.id AND users.id != '" . $_SESSION['id'] . "' LIMIT ". SmartyPaginate::getCurrentIndex() . ", ". SmartyPaginate::getLimit();;
$rs = $this->db->Execute($sql);

SmartyPaginate::setTotal($rs->RecordCount());
echo SmartyPaginate::setUrl('./index.php?mod=users&act=view');
$this->tpl->assign('results', array_slice($rs->fields, SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit()));
SmartyPaginate::assign($this->tpl);


Ok, the problem is i just got 10 results (should be 128). But if i set setTotal to the real number of rows, i got some undefined errors, but the pagination is working

Notice: Undefined index: format in E:\Workspace\Website\sim\includes\smarty\plugins\function.paginate_middle.php on line 59

Notice: Undefined variable: _ret in E:\Workspace\Website\sim\includes\smarty\plugins\function.paginate_middle.php on line 72

[barma3]

In your case $rs->RecordCount() returns number of records in your SQL query, where you are using limit param. So you have got 10 strings. Use separate query for SmartyPaginate::setTotal().

This is my variant: