1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
$Sql_liste="SELECT titre,timestamp as timestamp FROM br_news UNION SELECT news,timestamp as timestamp FROM br_mini_news order by timestamp DESC LIMIT ".$premiernewsAafficher.",".$nombreDenewsParPage;
$reponse = mysql_query($Sql_liste) or die("<br />Erreur sur <i>".$Sql_liste."</i><br /><br />Erreur : <br />".mysql_error());
while($donnees = mysql_fetch_array($reponse))
{
$Titre = $donnees['titre'];
$News = $donnees['news'];
$News_Timestamp = $donnees['timestamp'];
?>
<tr >
<td valign="top">
<?php
if(empty($News)) {echo $News;}
if(empty($Titre)) {echo $Titre;}
?>
<br />
<div align="right"><small><i><?php echo date('d/m/Y à H\hi', $News_Timestamp); ?></i></small></div>
</td>
</tr>
<?php
}
mysql_close();
?> |
Partager