I have a distinct php mysql query that grabs the MONTH(date_live) as 'month'
$month_name = date('F', mktime(0, 0, 0, $row['month']) );
...to turn the month number > month name.
This worked flawlessly until recently, now certain months don't convert!
Is there an alternative method to convert the month number > name without using mktime (in case somehoe that's depreciated??)
You could try to add a valid value for day and month to that mktime.
Or you could get the name of the month directly in your query: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_monthname
Actually I just figured a workaround, where I use strtotime on year/month/01
This topic is now closed. New replies are no longer allowed.