Hey Eric..
Thanks a lot it really helped me to figure out and I managed to do it.. there a few things I had to change from the codes you gave but it was excellent.. i understood it.. very easily. The final piece looks something like this:-
<?
if ($post == "yes") {
//THEN WE ARE ADDING A NEW RECORD SUBMITTED FROM THE FORM
//REPLACE THE FIELD CONTENTS SO THEY DON'T MESS UP YOUR QUERY
pg_query("BEGIN TRANSACTION;");
$query =
"INSERT INTO employee (fname,lname)
VALUES ('{$_POST["fname"]}','{$_POST["lname"]}')";
pg_query($query);
$query =
"SELECT empid FROM employee
WHERE fname ='{$_POST["fname"]}'
AND lname ='{$_POST["lname"]}'";
$result = pg_query($query);
$numrows = pg_numrows($result);
if ($numrows!=1)
{
// handle error case
pg_query("ROLLBACK;");
}
else
{
list($empID) = pg_fetch_array($result,0);
$query =
"INSERT INTO emp_info (empid, deptid, title, phone, email, link, room, rank)
VALUES('$empID','{$_POST["department"]}', '{$_POST["title"]}', '{$_POST["phone"]}', '{$_POST["email"]}',
'{$_POST["link"]}', '{$_POST["room"]}', '{$_POST["rank"]}')";
pg_query($query);
pg_query("COMMIT TRANSACTION;");
}
if (!pg_last_error())
{
echo "The employee <b>$fname, $lname</b> has been added to the database successfully";
} else {
echo "Error inserting record (9994SQL)".pg_last_error();
}
//***** END INSERT SQL *****
} //END IF POST = YES FOR ADDING NEW RECORDS
if (!$post) {
//THEN WE ARE ENTERING A NEW RECORD
//***** BEGIN ADD NEW FORM*****
/*-- SECTION: 9994FORM --*/
?>
<?php
} //END if post=""
//***** END ADD NEW ENTRY FORM*****
?>
Thanks Man
