Agenda van

= now() - INTERVAL 1 DAY) ORDER BY datum, tijd ASC"; $res = mysqli_query($link, $sql); while($r=mysqli_fetch_array($res)) { $datum=$r["datum"]; $weekdag=$r["dag"]; $datum2 = explode("-", $datum); $jaar=$datum2[0]; $maand=$datum2[1]; $maanden_array = array( "januari", "februari", "maart", "april", "mei", "juni", "juli", "augustus", "september", "oktober", "november", "december"); $maand_naam = $maanden_array[$maand-1]; $dag=$datum2[2]; echo ""; $sql2 = "SELECT * FROM agenda WHERE verid='$verenigingsid' AND datum='$datum' ORDER BY tijd ASC"; $res2 = mysqli_query($link, $sql2); while($r2=mysqli_fetch_array($res2)) { $tijd=$r2["tijd"]; $lokatieid=$r2["lokid"]; $sql21 = "SELECT name FROM lokaties WHERE id='$lokatieid'"; $res21 = mysqli_query($link, $sql21); while($r21=mysqli_fetch_array($res21)) { $lokatie=$r21["name"]; $feest=$r2["feest"]; $id=$r2["id"]; echo ""; } } } ?>
 
".$weekdag." ".$dag." ".$maand_naam."
".$tijd."".$feest."".$lokatie."