[RESOLVED] Proper syntax?

[Shamrox]

What is the proper mysql syntax for inserting a record into two tables at the same time?

[notaloser]

this can easily be looked up in the manual my friend..

mysql_query("INSERT INTO table1,table2 (field1, field2) VALUES (value1,value2)");

and of course this requires both tables to have both fields (field1 and field2)

[Shamrox]

Thanks. I was in the manual and couldn't seem to find it.

You saved me time AND got to stretch your fingers on the keyboard 😉

later.

[Shamrox]

What if I'm only inserting 2 fields into one table, and all fields into the other table?

[notaloser]

mysql_query("INSERT INTO table1,table2 (table1.field1, table1.field2, table2.field1, table2.field2, table2.field3) VALUES (bothvalue1, bothvalue2, bothvalue1, bothvalue2, t2value3)");

where table1.field1 is the same field table2.field1 and table1.field2 is the same field table2.field2

i think this is correct? someone correct me if im wrong

[Shamrox]

I found some other code that used two lines of inserts as seperate queries. That seemed to work. I'll also give your method a try just to know it if works as well.

Gracias.