date format

[esandra]

//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

[esandra]

never mind. its

SELECT DISTINCT MONTHNAME( date ) FROM arrastre