[eluser]gazza7364[/eluser]
Hi
I've been writing a blog while learning CI, but I've hit a block.
What I would like to do is make a archive section and would like to extract post from the database, based on month and year. The problem I have is the date and time is in unixtime. eg 1337358506. I'm not sure how I can query this time format, to get only blogs posted on say :- May 2012. Any pointers, I've looked on the net and user guide, but cannot find a solution. The only example I did find was $month = date("n", 5); $year = date("Y", 12), which tells me the the year is 2012 and the month 5.
Thanks in advance.