What I am trying to achieve is that if you get a month number, I would like to convert into month name i.e. March.
Now I've had a go, but it doesn't quite work because its not looping correctly, what I mean, it displays 'March'. Any ideas anyone?
$result=mysql_query("SELECT distinct MONTH(story_date) as month,YEAR(story_date) as year
FROM tbl_news WHERE tbl_news.ncid=$ncid
order by month asc");