knowram Posted May 16, 2007 Share Posted May 16, 2007 So I have this database with lots of info all time stamped with this format "May 15 2007 9:44AM". What I would like to be able to specify a date range and have only entries that are in that date range be pulled from the table so that I can post the results. I know this must be possible but I have no idea host to even start. Any and all ideas would be help full Thanks allot Quote Link to comment Share on other sites More sharing options...
john010117 Posted May 16, 2007 Share Posted May 16, 2007 date() and strtotime() might help. Quote Link to comment Share on other sites More sharing options...
ph2007 Posted May 16, 2007 Share Posted May 16, 2007 There may be better ways of doing it, but lately I've appreciated the function strtotime(). You could do something like: <?php $start = strtotime("May 10 2007 8:00 AM"); $end = strtotime("May 31 2007 11:59 PM"); if ((strtotime($db['timestamp']) >= $start) && (strtotime($db['timestamp']) <= $end)) /* do stuff here */ ?> Quote Link to comment Share on other sites More sharing options...
knowram Posted May 16, 2007 Author Share Posted May 16, 2007 I didn't know about strtotime(). Thats cool. Thanks 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.