remote connection php code

2004-07-20 Thread Business A2Z
Hi All

Could someone give me a clue or a snippet of PHP code I can test a romte
connection to my MySQL DB for my website please?

Thank you
Andrew


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: remote connection php code

2004-07-20 Thread jeffrey_n_Dyke


 Hi All

 Could someone give me a clue or a snippet of PHP code I can test a romte
 connection to my MySQL DB for my website please?

Just take the one you're currently using and replace 'localhost' with
'someotherserver.com'
$cnx = mysql_connect('someotherserver.com','uname','pword');
mysql_select_db('dbname',$cnx);
mysql_query('Select * from table',$cnx);
etc

As long as the GRANT's are set up to accept connections from an exteral
client and Firewall ports are open(if needed), it will not differ much from
local testing.

HTH
Jeff

 Thank you
 Andrew







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]