I have several modules in a PHP program that access a postgres database. The program needs to create a new "Name" record in a table is it has a new name or use a name chosen from the database if it doesn't have a new name. I want to load the chosen id in person_id if the name is already there, but it needs to have the current value of the name record index if it is not. I'm having trouble figuring our how to load currval(person_id_seq) into person_id. My code snippet appears below. I know that this code is wrong and I know that I need to process the resulting query as an array, but I can't figure out how.


$query = "INSERT INTO \"tblPeople\"(\"fName\",\"mName\",\"lName \", ivlweb, cnsweb) VALUES ('$f_name_new', '$m_name_new','$l_name_new', '$ivl_web_peop', '$cns_web_peop')";
                echo "First Name query: " . $query . "<br />";
$pg_peop_ins = pg_query($query) or die("Can't execute first query");

$query = "INSERT INTO \"tblContactInformation\"(\"contactItem \",\"contactType\") VALUES ('$contact_info1','$contact_type')";
                            echo "Second Name query: " . $query . "<br />";
pg_contact_ins = pg_query($query) or die("Can't execute 2nd query"); $query = "INSERT INTO \"brdgPeopleContactInformation \" (\"peopleId\",\"contactInformationId\",rank, type) VALUES (currval('\"tblPeople_peopleId_seq \"'),currval('\"tblContactInformation_contactInformationId_seq\"'), '$cont_rank', '$cont_loc')";
                echo "Third Name query: " . $query . "<br />";
$pg_peop_cont_ins = pg_query($query) or die("Can't execute 3rd query");
                $query = "SELECT currval('\"tblPeople_peopleId_seq\"')";
                $person_id = pg_query($query) or die("Can't execute 4th query");
echo "person id is " . $person_id . "<br />"; +++++++ (This gives me a Resource # - I know this is because I didn't process it as an array.) ++++++++

The other thing that puzzles me is that I thought the statements between the begin and the commit should be treated as one transaction. In this case, some of the tables get written and not others between the begin and the commit.

Thanks for your time.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to