[RESOLVED] Insert data in tables

[tams]

Hi,

I asked this question at mysql forums and I was told post it in a PHP forum so I hope someone can help me here.

I have a form with many different fields from which data will go to many different tables. What I want to know is whether I can do it all at the same time.
So I have
$query="INSERT INTO tbl1 (fields) VALUES(values)"; "INSERT INTO tbl2 (fields) VALUES(values)" ;
The above format is not correct and I want to know what is the correct format for doing all this in the same $query?

Thank you

[tams]

Still need help:o

[NogDog]

If using PHP5 with the [man]mysqli[/man] extension enabled, you can use the [man]mysqli_multi_query/man function. Otherwise you'll either have to submit each query separately, or if using MySQL5 you could create a stored procedure to to it.

[tams]

Thank you.

Since I am using mysql5 and PHP5, mysqli_multi_query() worked.🙂