Hello all,

Iam trying to connect to another location where the db is located and am having no success.

I keep on receiving the following error:

Fatal error: Call to undefined function: mysql_connect() in /home/uwo/wwwroot/testing/db_connect.inc on line 47


which is basically this code here...

$dbhost = '000.000.000';
$dbusername = 'username';
$dbuserpassword = 'pass';
$default_dbname = 'testing';
$user_tablename ='table';

function db_connect($dbname='') {
   global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
   global $MYSQL_ERRNO, $MYSQL_ERROR;

   $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
   if(!$link_id) {
      $MYSQL_ERRNO = 0;
      $MYSQL_ERROR = "Connection failed to the host $dbhost.";
      return 0;
   }
   else if(empty($dbname) && !mysql_select_db($default_dbname)) {
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
      return 0;
   }
   else if(!empty($dbname) && !mysql_select_db($dbname)) {
      $MYSQL_ERRNO = mysql_errno();
      $MYSQL_ERROR = mysql_error();
      return 0;
   }
   else return $link_id;
}

Now this code actually work in my test environment but does not work when I try to connect from a php page that I know works 100%. am I missing a variable somewhere. Cause On the linux box where the .inc file is located it return that error... I want it to go to a windows box which has the mysql db located...


Thanks for all your assistance..

Well, I can only assume you have PHP compiled without MySQL support. AS an aside, I seem to recall that Redhat installations, in particular, default to installing PostgreSQL support, but leave off MySQL support (damned stupid distribution, if you ask me - but we have ample evidence, from elsewhere, to show that ineptitude is no hinderance to becoming a software juggernaught).