$date_rss=array("0");$titre_rss=array("0");$id_rss=array("0");$cdz_rss=array("0");
$req1 = mysql_query("select * from news order by date desc limit 15");
$rank = 1;
while($view1 = mysql_fetch_object($req1)) {
$date = $view1->date;$titre = $view1->titre;$idx = $view1->idx;$cdz = 2;
array_push ($date_rss, "$date");
array_push ($titre_rss, "$titre");
array_push ($id_rss, "$idx");
array_push ($cdz_rss, "$cdz");
$rank++;
}
$req2 = mysql_query("select * from contenu order by date desc limit 10");
while($view2 = mysql_fetch_object($req1)) {
$date = $view2->date;$titre = $view2->titre;$idx = $view2->idx;$cdz = $view2->cdz;
array_push ($date_rss, "$date");
array_push ($titre_rss, "$titre");
array_push ($id_rss, "$idx");
array_push ($cdz_rss, "$cdz");
$rank++;
}
asort($date_rss);
for ($i = 0; $i !=11; $i++)
{
?>
<a href="index-<? echo $cdz_rss[$i] ?>-<? echo $id_rss[$i] ?>-0.html"><? echo $titre_rss[$i] ?></a> - le <? echo $date_rss[$i] ?><br/>
<?
}
?>

select * from table1 union select * from table2 order by date