I was wondering if there is anyway to get a result from one database on 1 domain to another database on another domain? For instance, www.domain1.com has a database table with "shares" as a specific row, column and another domain www.domain2.com table with "bids" as a specific row1,column.
How could I transfer domain1"shares" to domain2"bids" table column ?
or is this only possible if both tables share the same domain? I know how to connect to 2 different databases already but nothing seems to work for transferring information unless I do it manually. And with over 10000 people, I do not want to go through each one.
I would also like to set up a cron job to run this process every 15 min or 12 hours or 24 hours or whatever for example.
Can anyone help? Thanks!