RE: [PHP-WIN] remote DB access

if you behind the any firewall you must check 1039 port is open.. you can try this with "telnet 100.110.120.130 1039" command.. if telnet is connecting, port is open. -----Original Message----- From: Paul Wallace [mailto:paul.wallace@prosolutions-ap.com] Sent: Friday, January 04, 2002 12:19 PM To: php-windows@lists.php.net Subject: [PHP-WIN] remote DB access Hello, I have the code: #11 $db = mysql_connect("100.110.120.130", "root", ""); #12 mysql_select_db("DBname",$db); #13 $result = mysql_query("select * from gmember where gmember_id = '$login' and gmember_password = '$password'",$db); #14 $nrow=mysql_num_rows($result); #15 if ($nrow != "0") { my logic etc... to establish a connection from my site hosted in the USA, to a DB which is situated in Asia (the IP above is the IP of the DB host in Asia). When I try to read the DB I get the error: Fatal error: Call to unsupported or undefined function mysql_connect() in /cgi/mydir/login/loginprocess.php on line 12 Line 12 being the mysql_select. Can anybody offer anything? I this syntax PHP v4? If it is, that may answer it! The excerpt "undefined function mysql_connect()" could suggest this. Or is it possibly the ID/passwords? Before the system was uploaded to the remote hosting service, it was on a LAN where the syntax worked fine accessing another computer hosting the DB on the LAN. Thanks for any input. Paul. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net