remote DB access
| From: | Paul Wallace | 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.