Login

02-07-2011, 11:25 PM

[eluser]RobertB.[/eluser]
Maybe this help, I don't know why you are making extra columns for dates and months but I don't think that you need them.

This will return the 3 dates

Code:
WHERE dateofbirth >= '2010-08-02' AND dateofbirth <= '2010-08-03'

or

Code:
$this->db->where('dateofbirth >=', '2010-08-02');

$this->db->where('dateofbirth <=', '2010-08-03');

This will return the 1 date

Code:
WHERE dateofbirth > '2010-08-02' AND dateofbirth < '2010-08-03'

or

Code:
$this->db->where('dateofbirth >', '2010-08-02');

$this->db->where('dateofbirth <', '2010-08-03');

hope this is what you're looking for.