Re: [PHP] INSERT statement for JOINed tables

2002-01-18 Thread Miles Thompson
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

Re: [PHP] INSERT statement for JOINed tables

2002-01-18 Thread Michael Sims
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