$req = "SELECT * FROM actualite ";
$rep = mysql_query($req);
while ($res = mysql_fetch_assoc($rep)) {
$id = $res['id_actu'];
$texte = $res['texte_actu'];
echo "
".$texte."
";
$i++;
}?>
$req = "SELECT * FROM animation ";
$rep = mysql_query($req);
if( mysql_num_rows($rep)!="") { ?>
Animations :
| Date |
Lieu |
while ($res = mysql_fetch_assoc($rep)) {
$id = $res['id_anim'];
$lieu_anim = $res['lieu_anim'];
$date1 = $res['date_anim'];
$annee1= substr($date1,0,4);
$mois1= substr($date1,5,2);
$jour1= substr($date1,8,2);
$date1= $jour1."-".$mois1."-".$annee1;
$date2 = $res['date_anim_fin'];
$annee2= substr($date2,0,4);
$mois2= substr($date2,5,2);
$jour2= substr($date2,8,2);
$date2= $jour2."-".$mois2."-".$annee2;
if($date2!="00-00-0000"){
echo "| du ".$date1." au ".$date2." | ";
}
else{
echo "
| le ".$date1." | ";}
echo "".$lieu_anim." |
";
}?>
} ?>