include 'include/header_en.php'; ?> File of Upcoming events! include 'include/middle.php'; ?> include 'include/bd_connect.php'; $query = "SELECT * FROM evenements WHERE est_visible = 'oui' ORDER BY DATE_EVENEMENT"; $result = mysql_query($query); while ($val = mysql_fetch_array($result)){ $titre = $val["titre_en"]; $id = $val["id"]; $date_evenement = $val["date_evenement"]; list($date,$time) = explode(" ",$date_evenement); list($annee,$mois,$jour) = explode("-",$date); list($heure,$min,$sec) = explode(":",$time); $ts_event = mktime($heure,$min,$sec,$mois,$jour,$annee); $ts_now = time(); if ($titre != ""){ echo '
'.$titre.'
On '.$jour.'/'.$mois.'/'.$annee.' at '.$heure.'h'.$min.'