>
Lire les messages |
// variables
$nb = 10;
// connection bdd
$c = @mysql_connect("mysql.teichet.nexenservices.com","teichet","BimksMUT") or die("connection impossible");
@mysql_select_db('teichet',$c) or die("selection impossible");
// initialisation
if(empty($page)) $page = 1;
if(empty($total)){ // nombre total de résultats
$sql = "select count(*) as qte from ld";
$p = @mysql_query($sql,$c);
$total = @mysql_result($p,"0","qte");
}
// on determine debut du limit
$debut = ($page - 1) * $nb;
// requete sql
$sql = "select * from ld LIMIT $debut,$nb";
// parcours et affichage des résultats
if($p = @mysql_query($sql,$c)){
while($r = @mysql_fetch_array($p)){
$pseudo1=(stripslashes($r["pseudo"]));
$titre1=(stripslashes($r["titre"]));
$texte1=(stripslashes($r["texte"]));
$ville1=(stripslashes($r["ville"]));
}
// calcul du nombre de pages target='zone1'
$nbpages = ceil($total / $nb); // arrondi a l'entier superieur
// on affiche les pages
for($i = 1;$i <= $nbpages;$i ++){
echo "$i";
if($i < $nbpages) echo " - ";
}
}
// fermeture bdd
@mysql_close($c);
?>
|