run a query: select query from table order by id desc
hope this helps -----Original Message----- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 6:10 PM To: [EMAIL PROTECTED] Subject: [PHP] How to get the auto-incremented value? When I write a record to a MySQL db with an auto-incremented key column, say it's called "id", what's the easy to retrieve that value? Do I have to run a query? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php