Can anyone tell me how to read a mysql date file (yyyy/mm/dd) and display it as dd/mm/yyyy? Im using php.

I believe this extension will do what you are looking for:

www.kaosweaver.com/extensions/details.php?id=68&cid=5

Thanks. But what I need is the ability to reformat a date from a php mysql database query, not the current date. That extension simply displays the current date in a variety of formats.

I'm reading an excellent book at the moment called 'Dreamweaver MX: Advanced PHP Web Development'. I've just read a bit about displaying dates in different formats (it uses the 'explode' function). The example below doesn't take the date from a database, but it could be tweaked to do so without much effort:

<pre id=code><font face=courier size=2 id=code>
$userDate = "20/09/2002";
$dateArray = explode ("/" ,$userDate);

$americanFormat = $dateArray[1] . "/" . $dateArray[0] . "/" . $dateArray[2];
$mysqlFormat = $dateArray[2] . "-" . $dateArray[1] . "-" . $dateArray[0];

echo "The date in British Format is: " . $userDate . "&lt;br /&gt;";
echo "The date in British Format is: " . $americanFormat . "&lt;br /&gt;";
echo "The date in British Format is: " . $mysqlFormat . "&lt;br /&gt;";
</font id=code></pre id=code>

The opposite can be done to join the various elements of a date back into something that MySQL will recognise. This uses the 'implode' function. An example of it's usage is below. It takes an array (in this case the authors names, but it could be day, month and year taken from a form) and joins it together into a string ready to do whatever you want with it:

<pre id=code><font face=courier size=2 id=code>
$authorArray = array ("Bruno Mairlot", "Gareth Downes-Powell", "Tim Green";
$authors = implode (", ",$authorArray);
echo $authors;
</font id=code></pre id=code>

Let me know if the above is what you're after.

By the way... I think the extension above does reformat the date and not display the current date - at least that's what I use it for unless I'm mistaken.