Date Format MYSQL / PHP - again!

[Nath]

I've just read Svetly's entry in the forum and didn't manage to find my answer. I too have a MYSQL database which contains a date field stored in the standard MYSQL YYYY-MM-DD format. I live in England and I would like to display this on my website in the DD-MM-YYYY format. I use the date in drop down list boxes and the code looks like this:

<select name="WeekSelect" class="tableText" id="select2">
<?php
do {
?>
<option value="<?php echo $row_Week['weekID']?>"><?php echo $row_Week['date']?></option>
<?php
} while ($row_Week = mysql_fetch_assoc($Week));
$rows = mysql_num_rows($Week);
if($rows > 0) {
mysql_data_seek($Week, 0);
$row_Week = mysql_fetch_assoc($Week);
}
?>
</select>

Is this enough information to get some help???

Thanks in advance!

 

[Nath]

Solution

After posting this I finally figured the solution out. I used the following as my SQL statement and it works perfectly:

SELECT DATE_FORMAT(w.date, GET_FORMAT(DATE,'EUR')) AS date
FROM etc...

This replaced:

SELECT w.date
FROM etc...

I hope this helps others who are looking for similar solutions. The website for the syntax etc. is: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html