Re: [PHP] Best way to automatically get mySQL database.

2007-10-31 Thread Angelo Zanetti
Hi Jay Thanks again, Now how would I do the SELECT remote_stuff INTO local_table; ? as these are on two different MySQL connections? Im not sure if this is possible to do in one statement or query? Seems possible in theory but I'm not sure. original message: Im wondering the best to do

Re: [PHP] Best way to automatically get mySQL database.

2007-10-11 Thread Angelo Zanetti
thanks thought there was something simpler Jay Blanchard wrote: [snip] We've got a local system (PHP intranet) and we need to connect to a live mySQL server get some of the tables (contents) and overwrite the same tables in the local mySQL database. This needs to be done with PHP. Im wond

RE: [PHP] Best way to automatically get mySQL database.

2007-10-11 Thread Jay Blanchard
[snip] We've got a local system (PHP intranet) and we need to connect to a live mySQL server get some of the tables (contents) and overwrite the same tables in the local mySQL database. This needs to be done with PHP. Im wondering the best to do this. Is it to get all the information into resu