On Wednesday 21 August 2002 21:28, Smita Manohar wrote:
> hello,
> in my script i want to compare input date with date stored in database and
> want the result for date <= input date and sometime for date >= input date.
How is the date stored? What type of field?
> it didn't work for <= and >= o
age-
> From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 11, 2002 8:36 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Date comparison problem
>
>
> But I would like to do it the other way round. I mean for the solu
But I would like to do it the other way round. I mean for the solution
you have mentioned, I have to make the query on the whole record, then
compare the two dates and filter the right ones. I'd like to make the
query look like:
SELECT something FROM table WHERE datetime < "$form_date"
So I thin
This is how I do it:
date("m/d/Y",strtotime(odbc_result($rs,"ts")))
where $rs is the result set and "ts" is the name of the field containing the datetime.
<>< Ryan
-Original Message-
From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 8:21 AM
To: [EMAIL
