• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SOLVED: Changed to Unix date format, now I don't know how to just show the last months entries.

#1
[eluser]Joakim_[/eluser]
Hello.

Since I switched to store the dates in unix format I have run into a problem.

Before I stored the dates as "m/d/Y" and could filter to show only the last months entries with the code below:

Code:
$this->db->where('MONTH(entry_date)', date("m",strtotime("-1 month")));

Now this code wont work. Anyone know how to edit this code to work with unix time stamp stored in the db?

Thanks a lot! Smile


Messages In This Thread
SOLVED: Changed to Unix date format, now I don't know how to just show the last months entries. - by El Forum - 09-14-2008, 10:46 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.