syntax question

[affordit]

Can someone tell me whats wrong with this line? The and portion does not seem to be working.

$query = "select * from test WHERE end_date <= '". date('Y-m-d', strtotime('+ 5 days')) ."' AND remind_date = '0'";

[soycharliente]

Echo the query to see what it's actually trying to run.

[affordit]

select * from test WHERE end_date <= '2008-03-19' AND remind_date = '0'

[soycharliente]

That looks perfect to me. MySQL manual confirms the syntax for date comparison.

I have no idea man.

 

Try?

<?php
$end_date = date("Y-m-d", strtotime("+ 5 days"));
$remind_date = 0;
$query = "SELECT * FROM `test` WHERE `end_date` <= '$end_date' AND `remind_date` = '$remind_date'";
?>