qstr("1").' LIMIT %d,%d',SmartyPaginate::getCurrentIndex(),SmartyPaginate::getLimit()); $rc = $DB->Execute($_query); if(!$rc) print $DB->ErrorMsg(); else while(!$rc->EOF) { $_data[] = $rc->GetRowAssoc(false); $rc->MoveNext(); } $_query = "SELECT FOUND_ROWS() as total"; $rd = $DB->Execute($_query); if(!$rd) print $DB->ErrorMsg(); else $_row = $rd->GetRowAssoc(); $total = $rd->fields['total']; SmartyPaginate::setTotal($total); return @$_data; } require ('smarty/libs/SmartyPaginate.class.php'); SmartyPaginate::connect(); SmartyPaginate::setLimit(50); SmartyPaginate::setUrl('members.php'); $smarty->assign('members',get_members($DB)); SmartyPaginate::assign($smarty); $smarty->caching = $caching; include ('includes/menu.php'); if(isset($_GET['next'])){ @$next = htmlspecialchars((int)$_GET['next']); $smarty->display('members.php',$next); }else{ $smarty->display('members.php'); } SmartyPaginate::reset(); $smarty->display('footer.php'); ?>