[HOW]Insert 2 tables within a form submit?

[vzhen]

Hi,

I have a form that need to insert into 2 different tables.

Example:
products
id = auto-increment
products_img
id = auto-increment
products_id

since products.id is auto-increment when submitting this form. How to insert the products.id into products_img.products_id in the same time?

[NogDog]

Do the first insert, then use the appropriate function for the DB interface being used to get the insert ID (e.g. [man]mysql_insert_id/man if using the basic MySQL extension), then use that ID in the second query.