RE: [PHP] Auto-increment value
| From: | Faisal Abdullah | Date: | Wed, 18 Sep 2002 10:36:39 +0000 |
| Subject: | RE: [PHP] Auto-increment value | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116708@lists.php.net to get a copy of this message | ||
I tried that. It gives me 24807, instead of 5.
Or is oid is a reference to something else, which would
lead me to the '5' i'm looking for?
-- snip snip --
if($result = pg_exec($db, $sql))
{
$query = "success";
echo "oid : " .pg_last_oid($result);
}
-- snip snip --
Sincerely,
Faisal
-----Original Message-----
From: Marek Kilimajer [mailto:kilimajer@webglobe.sk]
Sent: Wednesday, September 18, 2002 5:42 PM
To: PHP
Subject: Re: [PHP] Auto-increment value
As he uses postgresql, he should use *pg_last_oid()*
Scott Houseman wrote:
> Hi there.
>
> You can use the function mysql_insert_id( [link id] ).
>
> regards
>
> Scott
>
> Faisal Abdullah wrote:
>
>> Hi people,
>>
>> I have a table with a column called ID (auto-increment).
>> Is it possible to know the value of ID, right after inserting a row?
>> I'm using postgresql.
>>
>> Thanks.
>>
>> Sincerely,
>> Faisal
>>
>> ______________________________________
>>
>>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
______________________________________