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@home.com] Sent: Thursday, November 16, 2000 10:45 AM To: php-general@lists.php.net 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@mindspring.com >>.>>.>>>.>>>>>.>>>>>>>>> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net