Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming date difference from db using codeigniter query
date difference from db using codeigniter query
  • El Forum
    Unregistered
  •  
#3
01-16-2013, 04:53 AM

[eluser]Bigil Michael[/eluser]
Thanks for your reply

problem is due to syntax.


solved like this


Code:
$mydate = date('Y-m-d');
$this->db->where("DATEDIFF('$mydate', c.dob) >=", 365);


Messages In This Thread
date difference from db using codeigniter query - by El Forum - 01-16-2013, 03:35 AM
date difference from db using codeigniter query - by El Forum - 01-16-2013, 04:50 AM
date difference from db using codeigniter query - by El Forum - 01-16-2013, 04:53 AM
date difference from db using codeigniter query - by El Forum - 01-16-2013, 05:11 AM
date difference from db using codeigniter query - by El Forum - 01-17-2013, 04:06 AM
date difference from db using codeigniter query - by El Forum - 01-17-2013, 11:10 AM
date difference from db using codeigniter query - by El Forum - 01-18-2013, 04:49 PM
date difference from db using codeigniter query - by El Forum - 01-18-2013, 09:06 PM
date difference from db using codeigniter query - by El Forum - 01-19-2013, 12:49 AM
date difference from db using codeigniter query - by El Forum - 01-19-2013, 03:19 AM
date difference from db using codeigniter query - by El Forum - 01-19-2013, 06:54 PM



Theme © iAndrew 2016 - Forum software by © MyBB