RE: [PHP] return most current insert row id From: Rodino, Justin Bain (justin <email protected>)
Date: 11/15/00

select max(oid) as id from TABLE;

pending that it is postgreSQL.....

________________________________________
Justin Rodino <justin <email protected>>
Web Application Developer
Golden Dome Media
PO Box 1616
Notre Dame, IN 46634
219.631.1116
219.674.0980
800.728.7979
219.631.1001 - fax
http://www.goldendome.com/
http://www.wndu.com/

> -----Original Message-----
> From: Maxim Maletsky [mailto:maxim.maletsky <email protected>]
> Sent: Wednesday, November 15, 2000 9:03 PM
> To: 'Tom Beidler'; php-general <email protected>
> Subject: RE: [PHP] return most current insert row id
>
>
> SELECT * FROM table ORDER BY id DESC LIMIT 1;
>
> will select all from the last entry to the first and limit
> itself to 1 row.
>
> hope it is the answer you needed.
>
> Cheers,
> Maxim Maletsky,
>
> -----Original Message-----
> From: Tom Beidler [mailto:tbeidler1 <email protected>]
> Sent: Thursday, November 16, 2000 10:45 AM
> To: php-general <email protected>
> Subject: [PHP] return most current insert row id
>
>
> How can I return the a row id that was inserted in the same
> page/function?
>
> I have a page where I display what was added to the cart.
> When I display the
> information that was just inserted I would like to be able to
> make that same
> page a recalculation page. That way the end user can immediately make
> changes to the displayed info, ie. quantity.
>
> To recalculate I need the item_id of the row I just inserted.
>
> I just saw this in the mailing list but can't find anything
> in the archives
> and I haven't had luck searching the manual.
>
> Thanks,
> Tom
>
> >>.>>.>>>.>>>>>.>>>>>>>>>
> Tom Beidler
> Orbit Tech Services
> 805.455.7119 (cell)
> 805.682.8972 (phone)
> 805.682.5833 (fax)
> tbeidler <email protected>
> >>.>>.>>>.>>>>>.>>>>>>>>>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>