genu Posted February 26, 2006 Share Posted February 26, 2006 Hi, I have this setup:[code] while($row = $mysqldb->fetchObject()) { $today = time(); $date = $row->startdate; $d = split("-",$date); $date_seconds = mktime(0,0,0,$d[1],$d[2],$d[0]); if ($today > $date_seconds) { //DO SOMETHING[/code]but the end result is this:http:genuchelu.redirectme.net/youth.phpBefore this query I have a query to extract all the article for that day, and this I have the query above to extract the articles from the past. After the current day articles are extracted, for some reason, query above starts extracting the past article STARTING with the current date. WHY IS THAT? I specifially put to be ">" as in to extract everything smaller, not ">=".any help is appreciated.this is my first time usage of these type of functions. Quote Link to comment https://forums.phpfreaks.com/topic/3619-solvedmktime-and-date-functions/ Share on other sites More sharing options...
Barand Posted February 26, 2006 Share Posted February 26, 2006 try replacing[code]$today = time();[/code]with[code]$today = mktime(0,0,0);[/code]to remove the time element from the current date. Quote Link to comment https://forums.phpfreaks.com/topic/3619-solvedmktime-and-date-functions/#findComment-12555 Share on other sites More sharing options...
genu Posted February 26, 2006 Author Share Posted February 26, 2006 ok thanks that worked Quote Link to comment https://forums.phpfreaks.com/topic/3619-solvedmktime-and-date-functions/#findComment-12591 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.