remote DB access

From: Date: Fri, 04 Jan 2002 10:19:25 +0000
Subject: remote DB access
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-11369@lists.php.net to get a copy of this message
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.

« previous php.windows (#11369) next »