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 <chiari.hm@xxxxxxxxxxx> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php