Alternative convert month number to name

PHP
1

I have a distinct php mysql query that grabs the MONTH(date_live) as ‘month’

I use:

$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??)

2

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

3

Actually I just figured a workaround, where I use strtotime on year/month/01 :slight_smile: