$nbr) { $page = ($nbr-$nbr%5)/5; } // We retrieve news according to the page we want to access for($i = $page*5; ($i < $nbr) && ($i < $page*5+5); $i++) { if (! mysql_data_seek($result, $i)) { continue; } if (! $row = mysql_fetch_row($result)) { continue; } // We display news list($year, $month, $day) = split("-", substr($row[0], 0, 10)); $news = $row[1]; $source = $row[2]; $link = $row[3]; $title = $row[4]; echo "\n"; echo " \n"; echo " \n \n \n"; if ($source != "") { echo " \n"; } else { echo " \n"; } echo "

$title ($day/$month/$year)

\n"; echo "

$news

\n"; if ($lien != "") { echo " $\"\"$ Link: $link\n"; } echo "

source: $source

\n"; } mysql_free_result($result); // We close the connection mysql_close(); // Is there a previous page? echo "

"; if ($page == 1) { echo "Previous page"; } if ($page > 1) { echo "Previous page"; } // Is there a next page? if ($page*5+5 < $nbr) { if ($page > 0) { echo " - "; } echo "Next page"; } echo "

\n"; ?>