exploding is the answer...
just enter the date("Y-,-d") into the database and then retrieve the date with a while loop: (the query is named $sql, and the column with the date in it is called date...)
<?
while($row=mysql_fetch_array($sql))
{
$exp=explode("-",$row[date]);
$date = $exp[2] . "-" . $exp[1] . "-" . $exp[0];
}
?>
This splits the date up at the -. After this has been done, you have three different "pieces": yyyy, mm and dd
yyyy=exp[0]
mm=exp[1]
dd=exp[2]
so the best thing for me (european) would be to put the day first, then the month and then the year. If you look in the $date field, you will notice the "-". This is the piece that goes between the exp's. So if you replace - with :, you will get this:
01:05:2001 (not really useful though...)
