date span wise search record

[eluser]php beginner[/eluser]
how can i search record between date means 2 apr to 12 apr

[eluser]Ben Edmunds[/eluser]
There are several ways. First, tell us what format your dates are in in your database.

[eluser]php beginner[/eluser]
yyyy-dd-mm format

[eluser]JoostV[/eluser]

Code:

$this->db->select("some_date BETWEEN '2010-04-02' AND '2010-04-12'", false);

[eluser]php beginner[/eluser]
thank u