[eluser]The Revel[/eluser]
[quote author="CroNiX" date="1336707191"]There is much that isn't in AR. It could also be that other databases that CI supports doesn't have equivalent commands.
For those I just use a regular where.
Code:
->where("field BETWEEN '2012-04-01' AND '2012-05-01'")
Which is about the same amount of text
as
Code:
->where(field)->between('2012-04-01', '2012-05-01')
[/quote]
Thanks for the help, worked like a charm, minus some spelling errors on my part, but worked none the less. Thank you again.
ALso the reason I think that ->between() should be added is because its a pain in the but to type in what I did:
Code:
->where('date BETWEEN "' . $date1 . '" AND "' . $date2 .'"')
would have been nicer and LESS typing is there was a
Code:
->between($date1, $date2)
Or even a
Code:
->where('date', between($date1, $date2))
It would be more efficient IMHO.