pikemsu28 Posted June 8, 2007 Share Posted June 8, 2007 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?? Link to comment https://forums.phpfreaks.com/topic/54761-solved-insert-into-two-tables-with-one-query/ Share on other sites More sharing options...
fenway Posted June 8, 2007 Share Posted June 8, 2007 What would that even mean? And yes, you need one insert per table. Link to comment https://forums.phpfreaks.com/topic/54761-solved-insert-into-two-tables-with-one-query/#findComment-271069 Share on other sites More sharing options...
pikemsu28 Posted June 8, 2007 Author Share Posted June 8, 2007 alright, thanks fenway Link to comment https://forums.phpfreaks.com/topic/54761-solved-insert-into-two-tables-with-one-query/#findComment-271071 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.