Comparing Two Dates 1

[pastorandy]

Hi

I am trying to compare two different DATE fields from a mysql DB. The two fields are DATE and not DATETIME.

Here's my query

$query6 = "SELECT * from holiday WHERE installer_id = 1 AND holiday_date = $row4[job_date]";

But I am not getting the expected results. If I output the two DATE variables they are the same but i'm not sure my comparison is correct.

 

[sleipnir214]

Since MySQL is going to want the date strings in the form YYYY-MM-DD, you're going to have to surround the dates with singlequotes. Otherwise, MySQL is going to treat your date string as a math problem.



Want the best answers? Ask the best questions! TANSTAAFL!