Hello, I want to merge two tables in a mysql database.... such that If content of 1st table changes via a php file then the other table(2nd) would update with the same info of 1st table fields... and if 2nd table is updated with another php file(which don't have any touch with 1st table) the first table would update... I think if it is possible it would be with some procedure in mysql , but i don't know if it is possible or not... Anyone could help me??
I think what you are looking for is triggers... http://dev.mysql.com/doc/refman/5.0/en/triggers.html Be carefull so you dont trigger a loop (table 1 trigger table 2, table 2 trigger table 1 again and so on)