Received: from web14401.mail.yahoo.com (web14401.mail.yahoo.com [216.136.174.58]) by postgresql.org (8.11.3/8.11.4) with SMTP id f9D4pfr63711 for ; Sat, 13 Oct 2001 00:51:41 -0400 (EDT) (envelope-from zsheran@yahoo.com) Message-ID: <20011013045140.50099.qmail@web14401.mail.yahoo.com> Received: from [196.40.43.219] by web14401.mail.yahoo.com via HTTP; Fri, 12 Oct 2001 21:51:40 PDT Date: Fri, 12 Oct 2001 21:51:40 -0700 (PDT) From: Zavier Sheran Subject: Nextval again To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200110/49 X-Sequence-Number: 602 Thanks for the help I received. I did run different queries like $number = pg_Exec ($db_connect, "SELECT nextval('members_recordid_seq')"); $number = pg_Exec ($db_connect, "SELECT last_value FROM members_recordid_seq"); What I get when I "echo $number;" is "Resource id #2", no matter what number the sequence is at (currently 19). If I run the same queries in phpPgAdmin I get the correct results. I run PHP 4.04 and PgSQL 7.03 Any ideas? __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com