linking to mysql databse externally

[Anon]

I would like to try and link to an external database (mysql)as an experiment.

I usually connect to the databse locally by using the include tag at the top of each page. The include tag points to my dbinfo.inc.php file and in this file are username, password and database name which connects me to my database. What do I need to add to this file, if I want to host my scripts externally.

//dbinfo.inc.php
<?
$username="user";
$password="pass";
$database="databasename";
?>

[Anon]

Try to make a file that contains the two connections. Like this:

//Save as dbinfo.inc.php

<?php

$Connection1 = mysql_connect("localhost","xxx","xxx");

$Connection2 = mysql_connect("www.yourserver.com","xxx","xxx");

?>

Then, include this in your other scripts-. When you make a mysql_query, you specify the connection upon the one to make it like:

$q = mysql_query("SELECT * FROM tbl",$Connection1);

$q2 = mysql_query("SELECT * FROM tbl2",$Connection2);

Hope this helps

fLIPIS

[Anon]

Thank you very much indeed.