Viridi Posted September 15, 2012 Share Posted September 15, 2012 Hello LarryUllman community, I come to you for help once again We're working on a child-website of a website with products. The information in these databases are the same, but the table names and attribute names differ. the table in website A might be named "products" while it's named "items" on website B. The same thing goes for the attributes, they might be named "productid" on A and "productnum" on B. (Edit: by the way, we can't simply modify the mySQLdump because the information will be updated every 24 hours, automatically) I'm still not that good with both mySQL and php but as far as I can see the only thing we can do is add the tables of website A to website B, and then change the SELECT (etc) codes in the php of website B to the table and attributenames of website A, or am I thinking in a too difficult matter? Help would be much appreciated, this is driving me insane! Link to comment Share on other sites More sharing options...
HartleySan Posted September 16, 2012 Share Posted September 16, 2012 You can do what you suggested, but an easier solution would be to change only the DB name, and leave all the table and column names the same. By doing that, the only thing that needs to change is the DB connected to via mysqli_connect. All other queries can remain the same. 1 Link to comment Share on other sites More sharing options...
Recommended Posts