I have no problem connecting, it's just the query() function doesn't want to go, it keeps telling me that no function exists.
I tried the code you wrote and it didn't produce any errors.
The following code is available at: http://beta.insyderhomielc.com/dbtest.php
<.?php
// Set the include path for when I'm working with PEAR ini_set("include_path","/usr/share/pear/"); // Grab DB for me include("/usr/share/pear/DB.php");
// My connection info that I use everywhere is in here include("functions/connect.mn.php");
// Now connect me $db = DB::connect("$server://$user:[EMAIL PROTECTED]/$database");
// Query to the db
$query = "SELECT * FROM ps_config WHERE site=1";
$result = $db->query($query) or die("I could not connect to the PageSite configuration table in the SQL database.");
// Store the results in an associative array $config = $result->fetchRow(DB_FETCHMODE_ASSOC);
?.>
If you need to see my php configuration go to: http://beta.insyderhomielc.com/php.php
I'll be honest, I am clueless. I don't have a single problem on my harddrive.
This is consistent though, I had the same problem on another CPanel based server.
- Stan