Re: remote DB access

What version of PHP do you have? It sounds like the functions for mysql are loaded, but those functions have been built in since about 4.0 I believe. Include the information for both of the servers.

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.

_________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com