RE: [PHP-DB] Date comparison problem

2002-07-11 Thread joakim . andersson
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

RE: [PHP-DB] Date comparison problem

2002-07-10 Thread Gabor Niederlaender
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

RE: [PHP-DB] Date comparison problem

2002-07-10 Thread Ryan Jameson (USA)
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