Time

krs1

Hey, as I was reading a different thread, I got to thinking... Can i compare time using "<" if I pass the date from my database through "strtotime"?

I have tried and failed... Arg... (maybe i am on the wrong track). I am looping some results from a MySql database, and one of my fields is a date (in MySql format yyyy/mm/dd). If that date is passed todays date I would like it to display text instead....

Here is what I have:

$today = strtotime(date("Y-m-d"));
mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");
$query="SELECT * FROM driver ORDER BY name";
$result=mysql_query($query);
$areanum=mysql_numrows($result);
$i=0;
while ($i < $areanum) {

$driverid=mysql_result($result,$i,"id");
$drivername=mysql_result($result,$i,"name");
$driverlicence=mysql_result($result,$i,"licence_expire")

 Echo ' <tr bgcolor="#'.$tblbgcolr[$tst = !$tst].'">';
 Echo '<td>';
 Echo $drivername;
 Echo '</td>';
 Echo '<td>';
     If (strtotime($driverslicence) > $today) {
      Echo '<span id="Expire">Expired!</span>';
    } else {
     Echo $driverlicence;
     }
 Echo '</td></tr>';

SumitGupta

Hi,

well my guess is that It works I just doesn't remember but I have done time and i guess this is how i use it with simple if statement no here and there in it...

just put two same formatted date in if statement and you will get it working as you want...just remember the same format...😃

Installer

If (strtotime($driverslicence) < $today)

krs1

Installer:

I had my equation the proper way, but it didn't work, when i turned it around that way everything showed expired (including stuff that shouldn't be expired) and I was getting -1 as a date...?

krs1

Okay I found that it was just a typo... Here is my current code:

$today = strtotime(date("Y-m-d"));
$tst = true;

mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");
$query="SELECT * FROM driver ORDER BY name";
$result=mysql_query($query);
$areanum=mysql_numrows($result);
$i=0;
while ($i < $areanum) {
$drivername=mysql_result($result,$i,"name");
$driverlicence=mysql_result($result,$i,"licence_expire");

$licenceexpire = strtotime($driverlicence);

 Echo ' <tr bgcolor="#'.$tblbgcolr[$tst = !$tst].'">';
 Echo '<td>';
 Echo $drivername;
 Echo '</td>';
 Echo '<td>';
     If ($today > $licenceexpire) {
      Echo '<span id="Expire">Licence: '.$licenceexpire.' Date'.$today.'</span>';
    } else {
     Echo $driverlicence;
     }
 Echo '</td></tr>';

This outputs:

Licence: 1104562800 Date1113544800

If i make the change:

 If ($today < $licenceexpire)

It outputs:

2005-01-01

Anyone understand why?

SumitGupta

Hi,

It is executing as intended for me...you have a driverlicence set to the Date format (yyyy-mm-dd) and than you simply convert it to the unix time stamp and compare.

In both of your cases your the If do what you have instructed it to do.. that is when Today is greater it display the if code in next you just check for the reverse and that time your statement is not true hence a else part is there..now the variable you display has different information on has timestamp of unix and other has the date format ..🙂

Am I clear???

krs1

Wow... Well thanks for looking into it... I don't know why its not executing for me... If the timestamp as before todays date it doesn't reconize it properly... Hmmm

If i change my "<" around all dates are considered expired, or all dates are okay... its freakin weird....

mrhappiness

Originally posted by krs1
This outputs:
Licence: 1104562800 Date1113544800
[...]
Anyone understand why? [/B]

because 1113544800 is bigger than 1104562800?

1113544800 - 1104562800 = 8982000

1113544800 = Fri, 15 Apr 2005 08:00:00 +0200
1104562800 = Sat, 1 Jan 2005 08:00:00 +0100

so i'ld say your statement executes the correct way

krs1

Well if the date is in the future it will still execute the expired statement.... .... I can post my code tomorrow....

My problem is I currently have 2 dates in my database on purposly expired (Jan 1 2005) and another date in the future (I think its Aug 23 2005).

With my current statement both dates will follow the "expired" path of my if statement... or both will follow the else path. But they will not apply the rules specific to their variable..... Get what I mean?