Nextval again

From: Zavier Sheran <zsheran(at)yahoo(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Nextval again
Date: 2001-10-13 04:51:40
Message-ID: 20011013045140.50099.qmail@web14401.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Papp Gyozo 2001-10-13 13:11:03 Re: Nextval again
Previous Message Josh Berkus 2001-10-12 16:49:44 Re: Nextval