Date and language

daantje79

When I query for a timestamp...

$query4 = "select date_format(datumtoeg,'%e %M %Y') from organisatie where orgcode = '$organisatie' ";
$result4 = mysql_query($query4);
while ($row4 = mysql_fetch_array($result4)){ ?>

and then echo it.....

<? echo $row4["date_format(datumtoeg,'%e %M %Y')"] ?>

I get as result....

6 March 2001

..What's the problem you might think.

Well i need this on a dutch page so I want the month to be in dutch.

Does anybody have any tips on how I can do this?

reagent

I don't know how to do it in mysql but you could always use an associative array and do this in your code

$arrMonth = array(
"JANUARY" => "<january in dutch>,
"FEBRUARY" => "...

then in your query
$strQuery = "
SELECT UCASE(DATE_FORMAT(datumtoeg, '%M')) as month_name
FROM organisatie
WHERE orgcode = '$organisatie'";

then when you do your echo
echo $arrMonth[$row["month_name"]];

so if $row["month_name"] == "JANUARY", you will get back whatever is in that associative array value as the translation.. sorry i don't know any dutch..