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?? Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.