X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8DB86D1B172 for ; Mon, 5 Jul 2004 06:09:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82206-03 for ; Mon, 5 Jul 2004 09:09:54 +0000 (GMT) Received: from kimi.asti.dost.gov.ph (kimi.asti.dost.gov.ph [202.90.128.26]) by svr1.postgresql.org (Postfix) with ESMTP id 8B0E1D1B267 for ; Mon, 5 Jul 2004 06:09:50 -0300 (ADT) Received: from falcon.asti.dost.gov.ph (unknown [10.10.5.200]) by kimi.asti.dost.gov.ph (Postfix) with ESMTP id 8D8CD2381C5 for ; Mon, 5 Jul 2004 16:48:43 +0800 (PHT) Subject: Re: Bad date external representation From: "Elijah O. Alcantara" To: pgsql-php@postgresql.org In-Reply-To: <40E90D8E.4070707@sancharnet.in> References: <1089014787.23599.31.camel@Falcon> <40E90D8E.4070707@sancharnet.in> Content-Type: text/plain Message-Id: <1089018590.23599.41.camel@Falcon> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Mon, 05 Jul 2004 17:09:50 +0800 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/3 X-Sequence-Number: 2828 Thanks for the reply =) But it looks like we have an old version of php - 4.0.6 pg_fetch_result (PHP 4 >= 4.2.0) =( it looks like I need to use pg_fetch_row instead. Thanks again, Elijah =) On Mon, 2004-07-05 at 16:13, V i s h a l Kashyap @ [Sai Hertz And Control Systems] wrote: > Dear Elijah , > > >Code: > > > > > >>$query = "Select date_created from organizationinfo where ctrl_no = > >>'$ctrl_no'"; > >>$date_created = pg_Exec($connectGovPH, $query); > >> > >>$query = "Select date_modified from organizationinfo where ctrl_no = > >>'$ctrl_no'"; > >>$date_modified = pg_Exec($connectGovPH, $query); > >> > >> > fetch results by pg_fetch_result and then insert the data > > >>$query = "Insert into temp_organizationinfo > >>VALUES('$ctrl_no','$organization_name','$domain_name','$loginID','$loginPassword','$date_created','$date_modified',4)"; > >>pg_Exec($connectGovPH, $query); > >> > >>