Erik,
You have to do two inserts. Have a look at
http://www.php.ca/manual/en/function.mysql-insert-id.php
Do your first insert
Call mysql-insert-id(), capturing its output.
Use the value returned in your second insert.
The returned value is unique to your connection; no need to lock the first
At 01:05 PM 1/18/2002 -0500, Erik Price wrote:
>I was hoping someone could share with me their code for situations like
>this, since I'm pretty sure it's a common situation: I need to insert a
>record into a table "files", and simultaneously insert a record into a
>table "files_users". "files
2 matches
Mail list logo