RE: [PHP] Hi How to compare two dates using PHP which are from mysql database?
| From: | Jan Rademaker | Date: | Tue, 12 Mar 2002 14:43:10 +0000 |
| Subject: | RE: [PHP] Hi How to compare two dates using PHP which are from mysql database? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-88205@lists.php.net to get a copy of this message | ||
On Tue, 12 Mar 2002, Balaji Ankem wrote:
> Hi Jan,
> I want to compare the DTAETIME1,DATETIME2 which are from mysql
> table and want to compare in PHP.
> But strtotime takes only one argument and it checks whether it
> is valid or not.
True, after you've fetched a record with, e.g. $row =
mysql_fetch_row($result) use
if (strtotime($row["DATETIME1"]) < strtotime($row["DATETIME2"])) {
...
}
or whatever you desire...
>
> Balaji
>
> -----Original Message-----
> From: Jan Rademaker [mailto:janr@486.yi.org]
> Sent: Tuesday, March 12, 2002 6:40 PM
> To: Balaji Ankem
> Cc: Php-General
> Subject: Re: [PHP] Hi How to compare two dates using PHP which are from
> mysql database?
>
>
> On Tue, 12 Mar 2002, Balaji Ankem wrote:
>
> http://www.php.net/manual/en/function.strtotime.php
>
> you can compare the results with > < =, etc...
>
> > Hi,
> > I would like to compare the two dates (including time stamp)
> using
> > php.
> > Is it possible?
> >
> > Any help would be apprciable.
> >
> > Thanks in advance
> > Balaji
> >
> >
>
>
--
Jan Rademaker <janr@486.yi.org>
http://www.ottobak.com