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 Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.