FUDforum: comp.lang.php » Copying data between databases

Home » Imported messages » comp.lang.php » Copying data between databases

Show: Today's Messages :: Polls :: Message Navigator

Re: Copying data between databases [message #174778 is a reply to message #174777]

Thu, 07 July 2011 04:51

Mick Gurling
Messages: 2
Registered: June 2011

Karma:

Junior Member

http://www.tonymarston.net/php-mysql/databaseobjects.html

Use his objects or read how he uses the database connections.

Mick

On Wed, 06 Jul 2011 23:41:57 -0500, Sloan wrote:

> Hi all,
>
> I'm a bit new to PHP, but have been programming in other languages for
> quite a while. I'm pretty good a SQL, including MySQL.
>
> Here's my question:
>
> How do I connect to two databases (on the same server) to use an INSERT
> .... ON DUPLICATE KEY UPDATE in PHP were the source table in one
> database, and the destination table is in another?
>
> I've written the SQL statement with explicit db.table.field references
> so I think I can use mysql_query, but which link do I use, or how can I
> pass both links?
>
> Thanks in advance!
>
> Sloan

Report message to a moderator

[Message index]

		Copying data between databases By: Sloan on Thu, 07 July 2011 04:41
		Re: Copying data between databases By: Mick Gurling on Thu, 07 July 2011 04:51
		Re: Copying data between databases By: Sloan on Thu, 07 July 2011 05:00
		Re: Copying data between databases By: The Natural Philosoph on Thu, 07 July 2011 06:09
		Re: Copying data between databases By: The Natural Philosoph on Thu, 07 July 2011 04:56
		Re: Copying data between databases By: alvaro.NOSPAMTHANX on Thu, 07 July 2011 06:28

Previous Topic:	multi-page form
Next Topic:	Earn $24.00 per Sign-Up!...Get Paided on all FREE MEMBERS!....{Sign-Up FREE}

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 13:50:12 GMT 2024

Total time taken to generate the page: 0.04706 seconds