Thanks everyone.. That's exactly what I needed :) --------------------------- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --------------------------- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." -- Albert Einstein [1879-1955]
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 4:37 PM To: Jason Frisvold; '[EMAIL PROTECTED]' Subject: Re: Auto Increment Fields At 4:08 PM -0400 10/4/01, Jason Frisvold wrote: >Is there a way to have DBI return the value of the auto-incremented field >upon insert? Or do I have to insert and then do a select afterwards? $dbh->do ("your insert statement"); $auto_inc = $dbh->{mysql_insertid}; -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
