Between operator not working in my code

Question

Between operator not working in my code. Please help me

    date_default_timezone_set('Asia/Kolkata');
    $today = date("m/d/y");
    $newdate = strtotime ( '-7 day' , strtotime ( $today ) ) ;
    $newdate = date ( 'm/d/y' , $newdate );  

    $query = mysqli_query($con, "SELECT * FROM service_calls WHERE open_date BETWEEN '$today' AND '$newdate'" );

It is giving me blank window after running this code.

I have open_date with format same as mentioned above.

Try using dates in international format: `Y-m-d` – Matteo Tassinari May 13 '13 at 06:57 — Matteo Tassinari, May 13 '13 at 06:57

score 1 · Answer 1 · edited May 23 '17 at 11:55

1

First - on blank pages in general
Second - on mysqli errors in particular
Third - you have to use proper Mysql date format (which is Y-m-d) in your table and queries

finally, you don't need PHP for such a query

SELECT * FROM service_calls 
    WHERE open_date BETWEEN CURDATE() AND CURDATE() - INTERVAL 7 DAY;

edited May 23 '17 at 11:55

Community

1
1

answered May 13 '13 at 07:00

Your Common Sense

156,878
40
214
345

score 1 · Accepted Answer · answered May 13 '13 at 07:01

1

Because in your database the date is in Y-m-d format, use this

date_default_timezone_set('Asia/Kolkata');
$today = date("Y-m-d");
$newdate = strtotime ( '-7 day' , strtotime ( $today ) ) ;
$newdate = date ( 'Y-m-d' , $newdate );

answered May 13 '13 at 07:01

Yogesh Suthar

30,424
18
72
100

Between operator not working in my code

2 Answers2