PHP/MYSQL copy fields in table to new table if data exists in fields

[Guest elthomo]

PHP/MYSQL copy fields in table to new table if data exists in fields.

 

To simplify I have some address data that I want users to be able to update but I also want to keep the old address. Could someone let me know the correct syntax for this?

[Isityou]

Pull the information from the old address and create a new entry with the new address. Than when the user updates it again delete the previous old address and repeat.

[Guest elthomo]

Thanks, But I actually mean the php/mysql syntax

[Isityou]

So you want someone to write the code for you?

[Guest elthomo]

No I understand the logic, but I'm unsure of the syntax. So what I would like to know is the syntax and not have the code written for me. I have unsuccessfully googled for the info required and could just use a little help.

[Guest elthomo]

Actually I think I may have found what I need INSERT INTO table_name SELECT * FROM table_name2 WHERE Field_Name = $field_name AND Field_Name2 = $$field_name2

[aschk]

Why are you copying this into another table? You going to create a new table every time a person's address changes

Just have it all in 1 table, and have a timestamp on the information. Then just pull the latest information using MAX(timestamp_column).

[Guest elthomo]

I didn't know that was possible!!! but i do now. So I will look into it thank you