RE: [PHP] inserting data to mutliple mysql tables

nd that if you didn't put me in the right direction so thank :) Cheers Peter -Original Message- From: Miguel Cruz [mailto:[EMAIL PROTECTED]] Sent: Monday, 13 May 2002 1:40 PM To: Peter Cc: Php Subject: Re: [PHP] inserting data to mutliple mysql tables This is a MySQL question, not

RE: [PHP] inserting data to mutliple mysql tables

You have to do separate inserts...you can't JOIN inserts like that... ---John Holmes... > -Original Message- > From: Peter [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 12, 2002 8:38 PM > To: Php > Subject: [PHP] inserting data to mutliple mysql tables > > Hi, > > I have a table that'

Re: [PHP] inserting data to mutliple mysql tables

This is a MySQL question, not a PHP question. Anyway, with MySQL you can't do this as a single operation. Do your inserts one after the other. You can use mysql_insert_id() after each one to get the value of an auto_increment field that was created, and feed that into your next SQL statement. m

RE: [PHP] inserting data to mutliple mysql tables

Isn't this more of a database question than a PHP question? -Original Message- From: Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1:38 PM To: Php Subject: [PHP] inserting data to mutliple mysql tables Hi, I have a table that's full of references to indexs in other tables