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); > >> > >>