Codeigniter: Using Active Record to search for rows between two dates?

Question

Is there a way to use codeigniters active record system to construct a query that will search for rows that fall between two dates (rows has an added field and I want to supply the query a start and end date)?

I have checked the documentation knowing that mysql includes a between keywork for such things but can't see anything related to it.

Thanks in advance

Boldewyn · Accepted Answer · 2010-05-18 09:13:05Z

2

You can just use two where() methods. They will be bound via AND, so if the first is 'everything after' and the second is 'everything before', you get a 'everything in between'.

If you want to use SQL goodies like NOW(), use where()s third parameter, and set it to False.

answered May 18, 2010 at 9:13

Boldewyn

83.1k45 gold badges161 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Codeigniter: Using Active Record to search for rows between two dates?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related