[RESOLVED] Date formats

[turtleton09]

OK - I looked at this a while ago (Nov 23). I have a mySQL database with a date entered field, and am just trying to display it more sensibly in the web pages.

I have a query that looks like :

mysql_select_db($database_Photolibrary, $Photolibrary);
$query_DateFormat = "SELECT date_format(Date_Added, '%D %b %Y') as formatted_date FROM photos";
$DateFormat = mysql_query($query_DateFormat, $Photolibrary) or die(mysql_error());
$row_DateFormat = mysql_fetch_assoc($DateFormat);
$totalRows_DateFormat = mysql_num_rows($DateFormat);

And I have my output code that looks like :

<?php echo $row_DateFormat['formatted_date']; ?>

Basically the day I did this I thought it was working fine, as records I added sure enough displayed as 23rd November 2006.

The trouble is that every record added since then also displays as 23rd November 2006, even tho' the actual date field in the database table has the correct date stored.

Any ideas what's going on here?

[stolzyboy]

are you looping thru the results? or just getting one?

[turtleton09]

D'oh! I had another query on the page already, but just forgot the WHERE clause in this one.

So just needed to change it to

("SELECT date_format(Date_Added, '%%D %%b %%Y') as formatted_date FROM photos WHERE Photo_ID = %s", $colname_DateFormat);

Thank you!

[bradgrafelman]

Don't forget to mark this thread resolved.