strange mysqli error

[Richard K Miller <richardkmiller@xxxxxxxxx>]

Good afternoon.  I'm getting a weird mysqli error in my object  
destructor.  Here's an example:

<?php

$db = new mysqli('localhost', USERNAME, PASSWORD, DATABASE);

class Test
{
	function __construct()
	{
		global $db;
		
		$db->query("SELECT 'test'");
		print_r($db->error);
	}

	function __destruct()
	{
		global $db;
		
		$db->query("SELECT 'test'");  // line 20
		print_r($db->error);  // line 21
	}
}

$test = new Test();

?>


A. On my dev machine (Mac OS X + PHP 5.1.4 + MySQL 5.0.19) I get the  
following errors EVERY time:
Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch  
mysqli in /Users/richard/Projects/data/private/mgftest.php on line 20
Warning: Test::__destruct() [function.Test---destruct]: Couldn't  
fetch mysqli in /Users/richard/Projects/data/private/mgftest.php on  
line 21

B. On my production server (FreeBSD + PHP 5.1.2 + MySQL 5.0.19) I  
SOMETIMES get the following error: (If I refresh the page repeatedly,  
sometimes there's an error, sometimes not.)
Warning: mysqli::query() [function.query]: Couldn't fetch mysqli in / 
usr/local/www/data/private/mgftest.php on line 20

C. On a commercial web host (PHP 5.0.4 + MySQL 5.0.22) I NEVER get  
any errors.

There's nothing else in my error logs, $db-errno is 0, and $db->error  
is empty.  Interestingly, I never get any errors from the constructor.

Any ideas?

Richard


---
Richard K. Miller
www.richardkmiller.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php