RE: [PHP] mysql auto increment question

bject: RE: [PHP] mysql auto increment question Hi Robbert, > Is there an easy way to find out what the auto_incremented > number is so I can use it to update the other table? Sure, have a look at mysql_insert_id: http://php.net/mysql_insert_id Cheers Jon -- PHP General Mailing

RE: [PHP] mysql auto increment question

Hi Robbert, > Is there an easy way to find out what the auto_incremented > number is so I can use it to update the other table? Sure, have a look at mysql_insert_id: http://php.net/mysql_insert_id Cheers Jon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.p

[PHP] mysql auto increment question

I have an application that updates two MySQL database tables. One table has an auto_increment id field. I need to use this id to link to an entry in the other table. Is there an easy way to find out what the auto_incremented number is so I can use it to update the other table? Robbert van An

Re: [PHP] mysql auto increment question

David Banning wrote: > > I am working with php-mysql > and am inserting into mysql using a NULL value, > which allows mysql to auto-insert (increment) > a number - how could I find out what the value was > mysql inserted, say on the next line of code after the insert? http://www.php.net/manual/e

[PHP] mysql auto increment question

I am working with php-mysql and am inserting into mysql using a NULL value, which allows mysql to auto-insert (increment) a number - how could I find out what the value was mysql inserted, say on the next line of code after the insert? -- PHP General Mailing List (http://www.php.net/) To unsub