coolzen0 43
| Posté : 08-12-2008 09:48
// Sélection de 10 articles aléatoires
$Result = mysql_query("select sid, title, DATE_FORMAT(time, '%a, %d %b %Y %H:%i:%s') as date_heure, hometext from stories order by rand() limit 0,$nb");
// Creation des items : titre + lien + description + date de publication
while($val=mysql_fetch_array($Result)) {
$xml .= '<item>';
$xml .= '<title>'.conf_XML($val["title"]).'</title>';
$xml .= '<link>http://wesra.free.fr/article.php?sid='.$val["sid"].'</link>';
//$xml .= '<description>'.conf_XML($val["hometext"]).'</description>';
//$xml .= '<description>en savoir plus sur '.conf_XML($val["title"]).'...</description>';
$xml .= '<description><![CDATA['.$val["hometext"].']]></description>' ;
//$xml .= '<pubDate>'.date("D, d M Y H:i:s",$val["time"]).' GMT</pubDate>';
$xml .= '<pubDate>'.$val["date_heure"].' GMT</pubDate>';
$xml .= '</item>';
}
|