I wrote a script for paginated output:

function pages($param) { $page_tmpl = ''; // объявляем переменную page_tmpl для использования return $pages_count = ceil($param['ents_count'] / $param['ents_print']); for($i = 1; $i <= $pages_count; $i++) { if($i == $param['page'] || !$param['page'] && $i == 1) $page_tmpl .= '<b>'.$i.'</b> '; else $page_tmpl .= '<a href="?page='.$i.'">'.$i.'</a> '; if($i != $pages_count) $page_tmpl .= ''; } return $page_tmpl; } (!intval($_GET['page'])) ? $start_page = 0 : $start_page = $_GET['page'] - 1; // выводим из таблицы support данные $query = mysql_query("SELECT * FROM `support` LIMIT $start_page, 2"); while($data = mysql_fetch_array($query)) { echo $data['qid'].'<hr />'; } // выводим переключатели страниц // 'ents_print' => 2 - сколько материалов отображать // 'ents_count' => 5 - сколько всего материалов в таблице support echo pages(array('page' => $_GET['page'], 'ents_print' => 2, 'ents_count' => 5));

So here. It turns out the curve output. Must

First page: 1 and 2

Second page 3 and 4

Third page 5 and 6

And now:

First page: 1 and 2

Second page 2 and 3

Third page 3 and 4

http://montytool.ru/system/modules/support/pages.php here is a link to the implementation.

    1 answer 1

    And reading about the LIMIT parameter in MySQL is not destiny?

     LIMIT start, count

    Those. it is necessary so:

     $start = $start_page * $param['ents_print']; $limit = $param['ents_print']; $query = mysql_query("SELECT * FROM `support` LIMIT $start, $limit");
    • @Photon, thank you. - ModaL