[Resolved] Selecting autocount

[Adhemar]

Hello,

I have two tables.
One table has an AUTOCOUNT column ID, the other a foreign key to ID.

After inserting a row to the first table (without specifying ID, of course), how can I find out the value of the ID column of this new row (so I can insert a row in the second table referencing the newly created row) BEFORE committing the transaction?

[tsinka]

Hi,

which database ?

[Hotkey]

Hi !

in case u are using php and mysql this will do the job :

mysql_query("INSERT INTO sometable (somecollum) VALUES ('somevalue');

$givenID=mysql_insert_id(); //gets the ID

now you got the ID ...

hope that helped ...

Hotkey