Datum vertalen

<?php
	include 'mysql.inc.php';
?>

<h3>Wedstrijdprogramma's</h3>
<p>
<?php
$result = mysql_query("SELECT * FROM Speeldata WHERE datum >= curdate() ORDER BY datum", $dbconn);
while (list($idSpeeldata, $klasse, $datum) = 
mysql_fetch_row($result)){
 echo("<a href=\"index.php?item=801&idSpeeldata=$idSpeeldata\">$klasse $datum </a><br>\n");
 }
 ?>
</p>

<h3>Uitslagen</h3>
<p>
<?php
$result = mysql_query("SELECT * FROM Speeldata WHERE datum <= curdate() ORDER BY datum desc", $dbconn);
while (list($idSpeeldata, $klasse, $datum) = 
mysql_fetch_row($result)){
 echo("<a href=\"index.php?item=802&idSpeeldata=$idSpeeldata\">$klasse $datum</a><br>\n");
 }
 ?>
</p>

<?php
	include 'mysql.inc.php';
?>
 
<h3>Wedstrijdprogramma's</h3>
<p>
<?php
$result = mysql_query("SELECT * FROM Speeldata WHERE datum >= curdate() ORDER BY datum", $dbconn);
while (list($idSpeeldata, $klasse, $datum) = 
mysql_fetch_row($result)){
 echo("<a href=\"index.php?item=801&idSpeeldata=$idSpeeldata\">$klasse $datum </a><br>\n");
 }
 ?>
</p>
 
<h3>Uitslagen</h3>
<p>
<?php
$result = mysql_query("SELECT * FROM Speeldata WHERE datum <= curdate() ORDER BY datum desc", $dbconn);
while (list($idSpeeldata, $klasse, $datum) = 
mysql_fetch_row($result)){
 echo("<a href=\"index.php?item=802&idSpeeldata=$idSpeeldata\">$klasse $datum</a><br>\n");
 }
 ?>
</p>

<?php
...
$result = mysql_query("SELECT idSpeelData , klasse , DATE_FORMAT(datum , '%e %M %Y') AS datum_formateert FROM Speeldata WHERE datum >= CURRENT_DATE() ORDER BY datum", $dbconn);
...
?>

<?php
...
$result = mysql_query("SELECT idSpeelData , klasse , DATE_FORMAT(datum , '%e %M %Y') AS datum_formateert FROM Speeldata WHERE datum >= CURRENT_DATE() ORDER BY datum", $dbconn);
...
?>

<?php
...
$date_eng = array('#Monday#' , ....);
$date_nl = array('Maandag' , ....);

//in je while
preg_replace($date_eng , $date_nl , $datum_formateerd);
?>

<?php
...
$date_eng = array('#Monday#' , ....);
$date_nl = array('Maandag' , ....);
 
//in je while
preg_replace($date_eng , $date_nl , $datum_formateerd);
?>