Search BTWN Dates in MYSQL

[weazy]

I have users that input a begin and end date and expect to see results that occurred on those dates and in between -- each record has a corresponding date.

How do I construct this WHERE clause?

Thanks.

[drew010]

assuming your field in the database for holding the dates is called dateField, and the values you pass in the where clause are the correct format, and the dateField is a valid mysql datetime, timestamp, date, etc type, you can do this:

$query = "SELECT * FROM table WHERE dateField > '{$_POST['beginDate']}' AND dateField < '{$_POST['endDate'] }'";

[weazy]

would that return reecords enter on the dates serving as parameters? or does the logic signs need an equal sign?

ex.
<= >=

[drew010]

it will only return ones greater, so if there is no time in the field you should use >= <= to get the same date the user enters