gusmacker Posted March 14, 2003 Share Posted March 14, 2003 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. Kevin Thanks in advance. the PHPFreaks forums have been such a blessing. Link to comment https://forums.phpfreaks.com/topic/226-date-query-question/ Share on other sites More sharing options...
shivabharat Posted March 14, 2003 Share Posted March 14, 2003 select * from <tablename> where <database field> >= <input from date> and <database field> <= <input to date> Hope this helps Link to comment https://forums.phpfreaks.com/topic/226-date-query-question/#findComment-668 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.