Re: re-using variables

On Tue, 27 Feb 2007 09:57:27 -0800, Mitesh wrote:


Ivan Marsh wrote:
On Tue, 27 Feb 2007 09:10:28 -0800, Mitesh wrote:

What I have discovered is re-using the $req variable is fine. While re-
using the $res produces undefined result (sometimes the second query
works fine and sometimes it doesn't. When I use different variables like
$res1 and $res2 the mysql queries always succeed. Is the initial
approach of re-using variable wrong if variables contain a
resource(reference type)?

In other words since PHP uses garbage collection re-using the same
variable can cause problems. Is this true?

Google: mysql free result

Thanx, but that doesn't address my question. I may have another type
of resource other than mysql result. So, should I be concerned about
re-using reference variables in PHP bound to some resource?

I haven't had any trouble with it... but then I tend to destroy/create
anything I'm going to re-use.

.

Relevant Pages

  • Re: re-using variables
    ... $res1 and $res2 the mysql queries always succeed. ... In other words since PHP uses garbage collection re-using the same ... re-using reference variables in PHP bound to some resource? ...
    (comp.lang.php)
  • Re: mysql_data_see for for() loops?
    ... I've masked out all the mysql stuff. ... it remains a valid resource pointing to ... pointer gets tested every time with is_resourceand it never ... And, as I said, the first row ...
    (comp.lang.php)
  • Re: Mysql::Simple?
    ... >>In that case I think your module belongs in DBIx not Mysql. ... The following script ... > resource handling, thus: ... > manually edited from a larger working client script and has ...
    (comp.lang.perl.modules)
  • Re: Looping from a fetcharray()
    ... need to do, is loop through the array, displaying each company name. ... // Assumes $result is MySQL Result Resource ... // Assumes $NumRows has already been populated with number of return ...
    (comp.lang.php)
  • Re: Connect to Remote Database
    ... Do you have the ODBC Connector for MySQL installed? ... > Hello, Veign ... >> Form Template: MySQL Connection Property Form: ... >> Veign's Resource Center ...
    (microsoft.public.vb.controls)