Inserting into 2 tables at one click

[Anon]

Hello

I want to insert some data into 2 of my tables through my PHP form.How can i do it?

For example, field1, field2 should be inserted into table 1 and field3, field4 should be inserted into table 2.

I'm able to insert into one table but not into 2 tables simultaneously.

Any help??

Thank you

[Anon]

Do it with two insert statements within a transaction.