PHP Active Record Find Rows Between 2 Dates

Question

I have just started to use php active record to select rows between 2 dates, it seems to work on some tests but on some it fails, this is what i have so far

$to = $_POST['to'];

$from = $_POST['from'];

$visitors = Visitors::find('all', array('conditions' => "visitdate >= '$from' AND visitdate <= '$to'"));

is there a between clause available?

Thank you

sbeliv01 · Accepted Answer · 2013-02-19 22:25:49Z

2

You'll need to designate visitdate as a DATE in order to compare the strings.

$visitors = Visitors::find('all', array('conditions' => "DATE(visitdate) BETWEEN '$from' AND '$to'"));

More here: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between

answered Feb 19, 2013 at 22:25

sbeliv01

11.8k2 gold badges26 silver badges25 bronze badges

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

1 Comment

sbeliv01 Over a year ago

Do you mind accepting the answer if it is indeed the correct solution to your question?

Collectives™ on Stack Overflow

PHP Active Record Find Rows Between 2 Dates

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related