Re: [PHP] Hi How to compare two dates using PHP which are from mysqldatabase?

2002-03-12 Thread Jan Rademaker

On Tue, 12 Mar 2002, Jason Lotito wrote:

> Why not compare them in the SQL Query itself?
> 

That could work just as well, depending in what you want to do with the
data.

-- 
Jan Rademaker <[EMAIL PROTECTED]>
http://www.ottobak.com



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP] Hi How to compare two dates using PHP which are from mysqldatabase?

2002-03-12 Thread Jan Rademaker

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:[EMAIL PROTECTED]] 
> 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 <[EMAIL PROTECTED]>
http://www.ottobak.com



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Hi How to compare two dates using PHP which are from mysqldatabase?

2002-03-12 Thread Jan Rademaker

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 <[EMAIL PROTECTED]>
http://www.ottobak.com



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php