SmartyPaginate::connect();
SmartyPaginate::setLimit(5);
SmartyPaginate::assign($smarty);

function showpytania()
{
         $_link = mysql_connect(HOST.":".PORT, USER, HASLO) or die ("ERROR: " . mysql_error());
         mysql_select_db(DBNAME) or die ("ERROR: " . mysql_error());
        
    
         $_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pytania ORDER BY id DESC LIMIT %d,%d",
         SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
        
         $_result = mysql_query($_query);
         while ($_row = mysql_fetch_array($_result, MYSQL_ASSOC))
         {
             $_data[] = $_row;
         }
         $_query = "SELECT FOUND_ROWS() as total";
         $_result = mysql_query($_query);
         $_row = mysql_fetch_array($_result, MYSQL_ASSOC);
        
         SmartyPaginate::setTotal($_row['total']);
        
         mysql_free_result($_result);
         mysql_close($_link);
         return $_data;
}
[/b][b]

{paginate_prev} {paginate_middle format="page"} {paginate_next}

[/b]
{paginate_prev} {paginate_middle format="page"} {paginate_next}
[b]