help me out

good time
please help me with the php code that feach data from a table and automaticaly insert it in another table withen the same database(mysql).

 

To create a new table with the same schema as an existing table, use

CREATE TABLE [b]new_table_name[/b] LIKE [b]orig_table_name[/b]

Code (markup):

You can then copy over all the records from the original table like so:

INSERT INTO [b]new_table_name[/b] SELECT * FROM [b]orig_table_name[/b]

Code (markup):

 

Trigger could do that ever time a record is updated it will update the other table