Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A68254761F2 for ; Fri, 5 Jul 2002 04:25:28 -0400 (EDT) Mailbox-Line: From joseph@asti.dost.gov.ph Fri Jul 5 04:25:28 2002 Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph [202.90.128.8]) by postgresql.org (Postfix) with ESMTP id D0D2147630C for ; Fri, 5 Jul 2002 04:25:20 -0400 (EDT) Received: from Askr (askr.asti.dost.gov.ph [10.10.5.36]) by kitana.asti.dost.gov.ph (Postfix) with ESMTP id 65F6A25845 for ; Fri, 5 Jul 2002 16:22:35 +0800 (PHT) Subject: comparing dates From: Joseph Syjuco To: PHP-PGSQL Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2-5mdk Date: 05 Jul 2002 16:33:29 -0400 Message-Id: <1025901211.1846.73.camel@Askr> Mime-Version: 1.0 X-Spam-Status: No, hits=3.3 required=5.0 tests=DATE_IN_FUTURE_12_24 version=2.30 X-Spam-Level: *** X-Archive-Number: 200207/7 X-Sequence-Number: 1309 how do i compare the current date to a date field in my database e.g. $current_date = date('Y=m-d'); $dbdate = pg_result($rsdate,0,"exam_date"); if ($current_date>$dbdate) --THIS PART DOESNT WORK echo "Today is not your exam date"; TIA