Welcome Guest, Not a member yet? Register   Sign In
SOLVED: Only show DB result from last month?
#1

[eluser]Joakim_[/eluser]
Hi.

I have some hard times showing only the last month entries from the DB.

Code:
$this->db->where('entry_date', date("m/d/Y",strtotime("last month")));

This code works but only show the entries with the same date as the current one. Somebody know how to make it show all entries from last month with any date? i have tried replacing the "d" and "Y" with "*" and even zeros but none of it work.


Any help are extremely appreciated! Thanks Smile


Messages In This Thread
SOLVED: Only show DB result from last month? - by El Forum - 07-06-2008, 06:34 AM
SOLVED: Only show DB result from last month? - by El Forum - 07-06-2008, 07:54 AM
SOLVED: Only show DB result from last month? - by El Forum - 07-06-2008, 08:04 AM
SOLVED: Only show DB result from last month? - by El Forum - 07-06-2008, 08:14 AM
SOLVED: Only show DB result from last month? - by El Forum - 07-06-2008, 08:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB