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

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 8 months ago.

Improve this question

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 ')'

Crysis could you show more code to understand your problem.. — Sunny S.M
– Sunny S.M, Commented Sep 18, 2015 at 7:02
Iam trying to replace $number1 and $number2 variables instead of 30 and 60. — Crysis
– Crysis, Commented Sep 18, 2015 at 7:03
i cant fetch the error but my page doesnt load, if i comment that line it works. — Crysis
– Crysis, Commented Sep 18, 2015 at 7:08
All you need to do is fix the spacing typos and remove the last double quote. $this->db->where("DATEDIFF(NOW(), date_and_time) BETWEEN $number1 AND $number2"); — mickmackusa
– mickmackusa ♦, Commented Apr 13 at 23:26

Karsten · Accepted Answer · 2015-09-18 07:25:26Z

2

You missed the space before and after the "AND":

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

answered Sep 18, 2015 at 7:25

Karsten

1,9163 gold badges18 silver badges36 bronze badges

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

2 Comments

saurabh kamble Over a year ago

$number1 and $number2 should be in proper mysql date format y-m-d

Karsten Over a year ago

@saurabh2836: I don't think so as ´DATEDIFF´ returns the number of days between two dates in MySQL.

Sunny S.M · Accepted Answer · 2015-09-18 08:28:52Z

2

Here my code :

I just make a query as on my own codeigniter project as following code:

$this->db->select();
$this->db->where("DATEDIFF(NOW(), dateCreated) BETWEEN 0 AND 10");
$this->db->get(tb_publishers);

Returned query by codeigniter function last_query() as :

SELECT * FROM (`tb_publishers`) WHERE DATEDIFF(NOW(), dateCreated) BETWEEN 0 AND 10

My output on phpmyadmin as follow

I hope error may occur due to no space around AND statement please correct that one...

edited Sep 18, 2015 at 8:28

answered Sep 18, 2015 at 8:14

Sunny S.M

6,0261 gold badge40 silver badges38 bronze badges

Comments

Mohan · Accepted Answer · 2015-09-18 07:54:26Z

1

TRY this :

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

answered Sep 18, 2015 at 7:54

Mohan

4,8597 gold badges47 silver badges70 bronze badges

Comments

Crysis · Accepted Answer · 2015-09-18 07:44:16Z

-1

Finally this one works

 $where=array("DATEDIFF(NOW(), date_and_time) BETWEEN $number1  AND  $number2");                         

  $this->db->where($where);

Thanks for the help and suggestion guys

answered Sep 18, 2015 at 7:44

Crysis

4162 gold badges7 silver badges28 bronze badges

1 Comment

Hanky Panky Over a year ago

If this works then the answer above should also work 100% just as fine. stackoverflow.com/questions/32645738/…

Collectives™ on Stack Overflow

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

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Related