Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:25896
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain kromann.info designates 64.186.239.125 as permitted sender)
To: <internals@lists.php.net>
Message-ID: <11595519486720000@9866357972520000.9866341568840000>
MIME-Version: 1.0
Reply-To: "Frank M. Kromann" <frank@kromann.info>
Date: Fri, 29 Sep 2006 10:45:48 -0700
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Subject: Variable reuse problem
From: frank@kromann.info ("Frank M. Kromann")

Hello Everyone,

I have a small problem with the mssql extension and resources (Tested with
PHP 5.2).

If I use the same variable to store the resource for a result the second
result is not always correct!

// Example 1 does not work
$rs = mssql_query("select 1");
$rs = mssql_query("select 3 select 2 select 1");

// Example 2 works fine
$rs1 = mssql_query("select 1");
$rs2 = mssql_query("select 3 select 2 select 1");

// Example 3 works fine
$rs = mssql_query("select 1");
mssql_free_result($rs);
$rs = mssql_query("select 3 select 2 select 1");

// Example 4 works fine
$rs = mssql_query("select 1");
unset($rs);
$rs = mssql_query("select 3 select 2 select 1");

The registered destructor is called in all four situations.

So why is there a difference between asigning a new resource value to a
variable with and without the unset()?

- Frank