|
$result=mysql_query("SELECT * FROM news WHERE AFFICHER='OUI' ORDER by id DESC LIMIT 0,1")
?>
while($row=mysql_fetch_array($result)){
if (trim($row["UPDAT"])<>"") {
$DATE = $row["UPDAT"];
} else {
$DATE = $row["DATE"];
}
$TITRE=$row["TITRE"];
if (strlen($TITRE)>57) {
$TITRE=substr($TITRE,0,57)."...";
}
$PHOTO = $row["PHOTO"].".jpg";
$AUTEUR = $row["AUTEUR"];
$EXTRAIT = str_replace(chr(13)," ",$row["ARTICLE"]);
$EXTRAIT = str_replace("","",$EXTRAIT);
$EXTRAIT = str_replace("","",$EXTRAIT);
$EXTRAIT=substr($EXTRAIT,0,300)."...";
$LIEN="REFNEWS.php?page=".$row["id"]."&action=".$action."&r=".$r;
}
?>
$debut=$page+1;
$fin=$page+10;
for( $i=$debut; $i < $fin; $i++ ) {
$result=mysql_query("SELECT * FROM news WHERE AFFICHER='OUI' ORDER by id DESC LIMIT ".$i.",1")
?>
while($row=mysql_fetch_array($result)){
if (trim($row["UPDAT"])<>"") {
$DATE = $row["UPDAT"];
} else {
$DATE = $row["DATE"];
}
$TITRE=$row["TITRE"];
if (strlen($TITRE)>57) {
$TITRE=substr($TITRE,0,57)."...";
}
$PHOTO = $row["PHOTO"].".jpg";
$AUTEUR = $row["AUTEUR"];
$EXTRAIT = str_replace(chr(13)," ",$row["ARTICLE"]);
$EXTRAIT = str_replace("","",$EXTRAIT);
$EXTRAIT = str_replace("","",$EXTRAIT);
$EXTRAIT=substr($EXTRAIT,0,300)."...";
$LIEN="REFNEWS.php?page=".$row["id"]."&action=".$action."&r=".$r;
}
?>
if ($i-$page<9) { ?>
}
}
$page=$page+10;
?>
if ($page<100) { ?>
>> Page suivante
} ?>
|
|
include("BANNIERE_PROMO_PODCASTS.php"); ?>
|
|