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 Link to comment https://forums.phpfreaks.com/topic/51678-help-with-comparing-dates/ Share on other sites More sharing options...
john010117 Posted May 16, 2007 Share Posted May 16, 2007 date() and strtotime() might help. Link to comment https://forums.phpfreaks.com/topic/51678-help-with-comparing-dates/#findComment-254542 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 */ ?> Link to comment https://forums.phpfreaks.com/topic/51678-help-with-comparing-dates/#findComment-254547 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 Link to comment https://forums.phpfreaks.com/topic/51678-help-with-comparing-dates/#findComment-254560 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.