//accès à la page
$debut= page*nbenrparpage
$query="SELECT... from ... LIMIT $debut,$nbenrparpage";
$result= mysql_query($query,$connexion);
while($row= mysql_fetch_object($result)){
echo $row->message;
}
//affichage des page dispos
$query="SELECT id from table";
$result=mysql_query($query,$connexion);
$nbenr= mysql_num_rows($result);
$nbpage= ceil($nbenr/$nbenrparpage);
for ($i=0; $i<$nbpage; i++){
echo "<A HREF='mapage?page=$i'>".($i+1)."</A>";
}