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);
--
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://www.saihertz.com
Yahoo IM: coeb_college[ a t ]yahoo.com
