inserting user_id in other tables

[Lv-Kris]

I have a need to insert the same user_id from users table into another table upon registering, however in the users table user_id is an auto incrementing number. If i put user_id of table2 auto incrementing there could be some id mixing if many people register at once. Maybe i could somehow link both id's? I was thinking about inserting another register page where if the id is not found, it inserts it...

Any ideas about solving this? Hope You get my idea...

Kris

[arianhojat]

using php? can use in variable right after insert...

mysql_insert_id()

 

or return it from another query after previous Insert query if not using php.

SELECT LAST_INSERT_ID() as lastRow;