Re: [PHP-DB] Simple question on auto_increment

2006-11-14 Thread Christian Flothmann
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

[PHP-DB] Simple question on auto_increment

2006-11-13 Thread mario
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

Re: [PHP-DB] Simple question on auto_increment

2006-11-13 Thread Brad Bonkoski
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

Re: [PHP-DB] Simple question on auto_increment

2006-11-13 Thread mario
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