Is there a way to grab the ID (from ID field) while INSERTing a new record?

I am currently doing a separate INSERT then a SELECT query to find the most
recently added record by that user:

select ID from table where user = '$user' order by ID DESC limit 0,1

This does the trick but it may not be the most efficient way.


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to