Jump to content


Photo

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


  • Please log in to reply
2 replies to this topic

#1 genu

genu
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 26 February 2006 - 07:24 AM

Hi, I have this setup:

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


#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 26 February 2006 - 09:46 AM

try replacing

$today = time();

with

$today = mktime(0,0,0);

to remove the time element from the current date.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 genu

genu
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 26 February 2006 - 04:44 PM

ok thanks that worked




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users