<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Document sans titre</title>
</head>
<body>
<?
$db=mysql_connect("sql.free.fr","****","****");
mysql_select_db("calendrier",$db);
$date_today= date("Y-m-d");
$sql = "UPDATE `calendrier` SET ok='o' WHERE `date_reel` < '$date_today'";
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$requete = "SELECT date_reel, quoi, où, infos FROM calendrier WHERE date_reel >= $date_today AND ok='n' ORDER BY date_reel ASC LIMIT 0,1";
$envoi = mysql_query($requete);

while($tableau = mysql_fetch_array($envoi))
{
$date_spect = $tableau['date_reel'];
$quoi = $tableau['quoi'];
$où = $tableau['où'];
$infos = $tableau['infos'];
$date_affich = date( "d/m/Y", strtotime("$date_spect") );
echo "texte=le $date_affich - $quoi - $où";
}
mysql_close()
?>
</body>
</html>
Partager