Re: [PHP-DB] Simple question on auto_increment
www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id (of course for your example to work all the other fields would have to be nullable) Or even the MySQL function LAST_INSERT_ID(): http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2725312 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Simple question on auto_increment
WOW! perfect, thanks a lot mario On Mon, 2006-11-13 at 16:16 -0500, Brad Bonkoski wrote: > mario wrote: > > Hello, > > > > really a mysql question. Pls. help anyway. > > > > Is there a simple, common way to implemt the following: > > Say I have a table with a id autoincrement field. > > I wish to insert a record but just ist id value, get back the id value, > > use it to update the record. > > > > Do I need three separate mysql queries? Is there some trick I may use? > > Thanks Regards mario > > > > > www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id > > (of course for your example to work all the other fields would have to > be nullable) > -- mario <[EMAIL PROTECTED]> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Simple question on auto_increment
mario wrote: Hello, really a mysql question. Pls. help anyway. Is there a simple, common way to implemt the following: Say I have a table with a id autoincrement field. I wish to insert a record but just ist id value, get back the id value, use it to update the record. Do I need three separate mysql queries? Is there some trick I may use? Thanks Regards mario www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id (of course for your example to work all the other fields would have to be nullable) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Simple question on auto_increment
Hello, really a mysql question. Pls. help anyway. Is there a simple, common way to implemt the following: Say I have a table with a id autoincrement field. I wish to insert a record but just ist id value, get back the id value, use it to update the record. Do I need three separate mysql queries? Is there some trick I may use? Thanks Regards mario -- mario <[EMAIL PROTECTED]> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php