I am having a table A...and i am copying(inserting) the content of the table A to the empty table B.I am doing changes in the values in table A ....but my table B always should remain constantly ...the changes done in table A should be reflected to the table B using php...please give me a solution to sort out my problem.

My problem is that, making changes in table A, its also reflecting to table B. But i don't need this.

7 Years
Discussion Span
Last Post by G&G Designing

Setup a mysql table that has 2 columns, Table A & Table B, then when you use a form to insert the data, have the data that goes in Table A to also go in Table B.

Then you can edit Table A without disturbing Table B


hi, can't understand....two columns or two table.please need more explanation.thanks


Ok so you have a database named


There is 1 table in that database
The table is named table1

table1 has 3 column

column 1 is named id with 11 and auto increment
column 2 is named new
column 3 is name old

Now you would have a form that inserts the data into both column new and column old in table1. Then you can update column new without editing column old.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.