insert into multiple tabels ...

[derheld]

Hi,
I have 3 tables:
1) customer
customerID
...
2)order
orderID
item_no
amount
3) link
customerID
orderID

Now I have a form that already contains in a hidden field the "customerID" and textfields to enter "item_no" and "amount".

when I submit the form, I would like to add
-to the table "order":
item_no, amount (orderID is auto_increment)
-and to the table "link"
customerID and the orderID (that just the data in the table "order" got)

what is the best way to do that?

[janhouse00]

As far as I'm concerned, the updated version of MySQL allows insertion of data into multiple tables at once. Check out the doc