Question by Yasin Hossain: php mysql code to update one table with values of another?
I have two identical tables with the same fields and datatype. Lets call the first one temp and the other final. I am trying to run a php script that will update my final table with values from my temp table.
I am new in php mysql and would appreciate your help.
Answer by Chris S
in ya php just insert to both tables at once
for example say if you are creating a social network site in php
when a user is registered in ya php u need to get his id and put it to other tables that need his id to work like a table for comments. a table for his profile picture.
so registers php u put his user name and password up to members table u then query the members table for his member id (the auto incrementing id) and u then save his member id to a variable and insert that variable to the comments table and the profile picture table so its ready for later when u create them features. this all happens in the register part.
What do you think? Answer below!
There are no revisions for this post.