SELECT WHERE mdate >= $startdate

[bulrush]

I would like to execute a SELECT statement where my field "mdate" (a DATE type field) is greater than or equal to the date the user entered, which is stored as a string in $startdate.

 

I still don't understand how to compare DATE type fields. Is a DATE type field stored as a string, or stored as an integer and displayed automatically as a string in the YYYY-MM-DD format?

 

Here is what I have that doens't work.

    $query = "SELECT mdate, miles, username, note, payrate, printdate ".
    "FROM mileage ".
    "WHERE (username='".$username."') ".
    "AND (mdate BEWEEN '$startdate' AND NOW()) ".
    "AND (printdate IS NULL) ".
    "ORDER BY mdate ".
    ";";

 

Thank you.

 

[PFMaBiSmAd]

As long as all the values have the correct (and same) format, the comparison will work.

 

now() is a DATETIME value and you should not be comparing it with a DATE value. See CURDATE()

[Mchl]

now() is a DATETIME value and you should not be comparing it with a DATE value.

 

Can lead to some tricky to find bugs.