query($sql_query); if (DB::isError($reviews_count_query)) die("SQL Error: " . $reviews_count_query->userinfo); if (empty($current_page_number)) $current_page_number = 1; $offset = ($max_rows_per_page * ($current_page_number - 1)); $sql_query .= " limit " . $offset . ", " . $max_rows_per_page; $query_num_rows = $reviews_count_query->numRows(); } function display_links($query_numrows, $max_rows_per_page, $max_page_links, $current_page_number, $parameters = '') { global $PHP_SELF; $parameters = ($parameters == '') ? '' : $parameters . '&'; $num_pages = intval($query_numrows / $max_rows_per_page); if ($query_numrows % $max_rows_per_page) $num_pages++; // has remainder so add one page if ($current_page_number > 1) echo 'Principio '; $cur_window_num = intval($current_page_number / $max_page_links); if ($current_page_number % $max_page_links) $cur_window_num++; $max_window_num = intval($num_pages / $max_page_links); if ($num_pages % $max_page_links) $max_window_num++; if ($cur_window_num > 1) echo 'Paginas Anteriores '; if ($current_page_number > 1) echo 'Pagina Anterior '; for ($jump_to_page = 1 + (($cur_window_num - 1) * $max_page_links); ($jump_to_page <= ($cur_window_num * $max_page_links)) && ($jump_to_page <= $num_pages); $jump_to_page++) { if ($jump_to_page == $current_page_number) { echo '[' . $jump_to_page . '] '; } else { echo '' . $jump_to_page . ' '; } } if (($current_page_number < $num_pages) && ($num_pages != 1)) echo 'Proxima Pagina '; if ($cur_window_num < $max_window_num) echo 'Paginas Siguientes '; if (($current_page_number < $num_pages) && ($num_pages != 1)) echo 'Fin '; } function display_count($query_numrows, $max_rows_per_page, $current_page_number, $text_output) { $to_num = ($max_rows_per_page * $current_page_number); if ($to_num > $query_numrows) $to_num = $query_numrows; return sprintf($text_output, ($max_rows_per_page * ($current_page_number - 1))+1, $to_num, $query_numrows); } } ?> '; reset($values); while (list($key, $value) = each($values)) { $result .= '