Asheeown Posted January 24, 2007 Share Posted January 24, 2007 In the table I want to call information out of I have a date and time that it was entered and I have the form setup to post what date range they want to view but how do I call a range out from a table?The way the database time record is setup:[code]yyyy-mm-dd hh-mm-ss[/code]And I have the form posting the range they want and combined Link to comment https://forums.phpfreaks.com/topic/35467-calling-database-info-by-date-range/ Share on other sites More sharing options...
Jessica Posted January 24, 2007 Share Posted January 24, 2007 SELECT * FROM table WHERE yourDate > '$begin' AND yourDate < '$end'Where $begin and $end are formatted the same way.AFAIK this will work. Link to comment https://forums.phpfreaks.com/topic/35467-calling-database-info-by-date-range/#findComment-167829 Share on other sites More sharing options...
Asheeown Posted January 24, 2007 Author Share Posted January 24, 2007 Never thought it would be that easyThanks much Link to comment https://forums.phpfreaks.com/topic/35467-calling-database-info-by-date-range/#findComment-167833 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.