Jump to content

Archived

This topic is now archived and is closed to further replies.

genu

**solved**mktime() and Date() functions

Recommended Posts

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.php

Before 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.

Share this post


Link to post
Share on other sites
try replacing

[code]$today = time();[/code]

with

[code]$today = mktime(0,0,0);[/code]

to remove the time element from the current date.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.