Two insert query... in the same click

Question

I have two text fields and a button, on the click i need to save them into MySQL Tables.

The top text box field data in table 1 and data in text box in table two...

How to perform it.

Answer 1

As MySQL does not seem to support multiple inserts in otwo tables you can do it with a transaction with two inserts or with a stored procedure.

Answer 2

Well, i guess your form execute some server-side PHP. Then in this PHP juste use mysql_query() 2 times, with your 2 insert.