smerny Posted July 8, 2009 Share Posted July 8, 2009 hard to explain fully in title... anyway, i want to create 1 row each in 2 tables at the same time (2 queries one after another i guess)... and i want to use the primary key of the row in the first table in row in the second table... so if the primary key in the row in the first table is 15, i want one of the fields in the row in the second table to also be 15 i could do a count rows, but it may be messy in the future if rows are deleted...whats the best way to do this? Quote Link to comment https://forums.phpfreaks.com/topic/165124-solved-creating-rows-in-2-seperate-tables-taking-the-primary-key-of-the-row-in-one/ Share on other sites More sharing options...
seventheyejosh Posted July 8, 2009 Share Posted July 8, 2009 mysql_query("INSERT INTO `table` (`a`,`b`) VALUES ('$a','$b')"); $id=mysql_insert_id(); mysql_query("INSERT INTO `table` (`id`,`a`,`b`) VALUES ('$id','$a','$b')"); like so? Quote Link to comment https://forums.phpfreaks.com/topic/165124-solved-creating-rows-in-2-seperate-tables-taking-the-primary-key-of-the-row-in-one/#findComment-870706 Share on other sites More sharing options...
jkewlo Posted July 8, 2009 Share Posted July 8, 2009 MySQL InnerJoin or google.com table joins Quote Link to comment https://forums.phpfreaks.com/topic/165124-solved-creating-rows-in-2-seperate-tables-taking-the-primary-key-of-the-row-in-one/#findComment-870729 Share on other sites More sharing options...
smerny Posted July 8, 2009 Author Share Posted July 8, 2009 seven, that was exactly what i was looking for, thanks jkewlo, i was looking to make rows, not call them Quote Link to comment https://forums.phpfreaks.com/topic/165124-solved-creating-rows-in-2-seperate-tables-taking-the-primary-key-of-the-row-in-one/#findComment-870806 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.