Jump to content


This topic is now archived and is closed to further replies.


Date Query Question.

Recommended Posts

I am using a php site that was created for real estate agents. I am adding a new part to the already created program to display and link open house information to each house. I have most of it done however I have one part I am had to make some changes to and now I can\'t seem to figure out what the query would be to get it to do what I want to do. Both fields are setup as date (yyyy-mm-dd) (I believe its mm-dd and not dd-mm) Anyways I have a field start_date and one end_date basicly I want to do a query and if the date is between the start and end date or is the start or end date I want it to get those results. If it is not between those dates I don\'t want it displayed.




Thanks in advance. the PHPFreaks forums have been such a blessing.

Share this post

Link to post
Share on other sites
select * from <tablename> where <database field> >= <input from date> and <database field> <= <input to date>



Hope this helps

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.