[SOLVED] Creating rows in 2 seperate tables, taking the primary key of the row in one

[smerny]

hard to explain fully in title... anyway, i want to create 1 row each in 2 tables at the same time (2 queries one after another i guess)... and i want to use the primary key of the row in the first table in row in the second table...

 

i could do a count rows, but it may be messy in the future if rows are deleted...whats the best way to do this?

 

 

[smerny]

solved here

 

http://www.phpfreaks.com/forums/index.php/topic,259640.0.html