PHP5 & classes & mysql bug ?

[Viacheslav Kaloshin <multik@xxxxxxxxx>]

Here is testcase

PHP 5.0.3 (cli) (built: Dec 17 2004 10:47:41)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.3, Copyright (c) 1998-2004 Zend Technologies


<?php
class MySQL {
	private $mysql_link=0;
	private $mysql_result=0;
	
	function __construct()	{
		$host="localhost";
		$basename="test";
		$username="test";
		$userpassword="";
		
		$link=mysql_pconnect($host,$username,$userpassword);
		if($link)
			{ mysql_select_db($link); 
				$this->$mysql_link=$link;
				echo "At constructor: ";
				echo $this->$mysql_link;
				echo "\n";
				return 0;
			}
			else
			{
				return 1;
			}
	}
	function __destruct() {
		echo "At destructor ";
		echo $this->$mysql_link;
		echo "\n";
			if($this->$mysql_link) { mysql_close($this->$mysql_link); }
	}
	
	function query($query_string) {
		
		echo "before query: ";
		echo $this->$mysql_link;
		echo "\n";
		$this->$mysql_result=mysql_query($query_string);
		// can change to this
		#$this->$mysql_result=mysql_query($query_string, $this->$mysql_link);
		echo "after query: ";
		echo $this->$mysql_link;
		echo "\n";
		if($this->$mysql_result)
			{ return 0; }
			else
			{ return 1; }
	}
	function result() {
		return mysql_num_rows($this->$mysql_result);
	}
	function fetch() {
		return mysql_fetch_array($this->$mysql_result, MYSQL_NUM);
	}
	function clear() {
		return mysql_free_result($this->$mysql_result);
	}
	
}

$m= new MySQL();

$m->query("select 1+2");
$res=$m->result(); 
$res=$m->fetch();
$m->clear();
$m->query("select 2+3");
$res=$m->result();
$res=$m->fetch();
$m->clear();

?>

this script output should shwo the same id. but in my case i see next lines:

At constructor: Resource id #4
before query: Resource id #4
after query: Resource id #5
before query: Resource id #5
after query: Resource id #6
At destructor Resource id #6

What i am not understand?

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