//I need to take the month from the `today`(date) field and format this into `F`(January-December)
//then display this in a drop down.
//So this is how my query looks like:
"select distinct substring(date, 6, 2) as month from arrastre order by month"
//and the drop down ouputs 06, 07, 08, and 09
//the problem starts when I add this line:
$month = date('F',strtotime($mrow['month']));
//..to format the month but it would only display january 4 times instead of june, july, august, september
//How do I change this so it would format the month exactly as it should
Date Format
Moderator: General Moderators
Re: Date Format
never mind i got it now:
SELECT DISTINCT MONTHNAME( date ) FROM arrastre
SELECT DISTINCT MONTHNAME( date ) FROM arrastre