Posted by Jerry Stuckle on 10/13/36 11:44

Dejan wrote:
> Hy
>
> Sorry for my terreble english.
> I have mysql table1 on my local comp. It looks something like this.
>
>
> ----------------------------------------------------------------------------
> -
> broj_tel | poruka | sifra |
> grad | id |
> ----------------------------------------------------------------------------
> |
> +385912701600 0 Zprod rijeka
> 5 |
> ----------------------------------------------------------------------------
> |
> +385912701699 1 kprod crikvenica
> 3 |
> ----------------------------------------------------------------------------
> -
>
>
> On the remote server (web hosting) i have table2 looking something like
> this:
>
> ----------------------------------------------------------------------------
> ---------
> id_independant | Name | Surname | broj_tel
> | poruka |
> ----------------------------------------------------------------------------
> --------- |
> 11122 Martin Johnes
> +385912701600 1 |
> ----------------------------------------------------------------------------
> ----------|
> 16163 John Doe
> +385912701699 0 |
> ----------------------------------------------------------------------------
> ----------
>
> Question: I nead periodicly (some scheduler, my concern) to make something
> like this:
>
> select * from table1
> insert into table2 (poruka) whare table1.broj_tel = table2.broj_tel
>
> To read the data from table1, and inserts into table2 coloumn poruka whare
> tabel1.broj_tel i equal table2.broj_tel
> Problem is that the data is in diferent databases.
>
> Any ideas?
> Tnx in advance
> Dejan
>
>
>

This isn't a PHP question. I'd suggest you try a MySQL group - such as
comp.databases.mysql.

Depending on your version you might be able to do something with replication.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]