Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 18EA9475D93 for ; Wed, 13 Nov 2002 22:52:01 -0500 (EST) Received: from little.gearcc.com (offback-ip05.wmis.net [216.109.193.78]) by postgresql.org (Postfix) with ESMTP id 5141D475D87 for ; Wed, 13 Nov 2002 22:52:00 -0500 (EST) Received: from offback2000 (wkst74.gearcc.com [216.109.193.74]) by little.gearcc.com (Postfix on SuSE Linux 7.2 (i386)) with SMTP id 37B431D470; Wed, 13 Nov 2002 22:53:58 -0500 (EST) Message-ID: <032801c28b91$752b5c90$4ac16dd8@offback2000> From: "Phil Geer" To: "Ray Hunter" , References: <1037217368.6700.113.camel@pclnxrhunter.digitalglobe.com> Subject: Re: serial type question Date: Wed, 13 Nov 2002 22:53:55 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/63 X-Sequence-Number: 1645 For Question #2 this is how I handle it. $query = pg_Exec( $dbconnect, "select nextval(table_name_seq);"); Store that value in a variable then you can insert it into your table1 with the serial (PK) and into the table2 as a reference. $query = pg_Exec( $dbconnect, "insert into table1 (serial, col1, col2) values (variable_set_by_nextval, data1, data2); insert into table2 (table2_PK, table2_col1, table2_col_that_references_table1) values(table2_PK_data , table2_col1_data, variable_set_by_nextval);"); You may also want to take a look at this section of the postgresql manual it'll be of help. http://www.postgresql.org/idocs/index.php?functions-sequence.html As for Question #1 it should work just fine if you do a begin and commit $query = pg_Exec( $dbconnect, "BEGIN WORK; insert into table1 (serial, col1, col2) values (variable_set_by_nextval, data1, data2); insert into table2 (table2_PK, table2_col1, table2_col_that_references_table1) values(table2_PK_data , table2_col1_data, variable_set_by_nextval); COMMIT WORK;"); Good Luck Phil ----- Original Message ----- From: "Ray Hunter" To: Sent: Wednesday, November 13, 2002 2:56 PM Subject: [PHP] serial type question > I have a php script that will be inserting from a form into two tables. > > Table1 has a serial data type. > Table2 references Table1's serial data type (PK). > > Here are my questions: > 1. Can i run a transaction process from php? If yes, how? > 2. How can i get the serial value for inserting into the 2nd table? > > > -- > Thank you, > > Ray Hunter > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >