phpmysqlcodeigniteractiverecordwhere-clause

CodeIgniter where() method call with DATEDIFF and BETWEEN has a syntax error

I am trying to execute query in CodeIgniter`, this one works:

$this->db->where("DATEDIFF(NOW(), date_and_time) BETWEEN 30 AND 60");

But this shows error my controller doesn't load, what I am doing wrong?

$this->db->where("DATEDIFF(NOW(), date_and_time) BETWEEN" .$number1. "AND".$number2.")";

Type: ParseError

Message: syntax error, unexpected ';', expecting ')'

Solution

  • TRY this : 

    $this->db->where( "DATEDIFF (NOW(), date_and_time) BETWEEN ".$number1. " AND ".$number2." ",null, false);