[SOLVED] insert into two tables with one query

[pikemsu28]

i'm not even sure this is possible but i was wondering if i can update/insert two tables at the same time using one query?

 

something like this:

$query = "insert into table1, table2 (table1.col1, table1.col2, table1.col3, table2.col1, table2.col2, table2.col3) values ('%s','%s','%s','%s','%s','%s')

 

is this possible or would i need to create a transaction or function, or am i totally off base here and this is not possible??

[fenway]

What would that even mean? And yes, you need one insert per table.

[pikemsu28]

alright, thanks fenway