Posted by Mitesh on 02/28/07 13:14

Jerry Stuckle wrote:
> Michael Fesser wrote:
> > .oO(Jerry Stuckle)
> >
> >> Toby A Inkster wrote:
> >>
> >>> You have:
> >>>
> >>> $res = mysql_query("SELECT * FROM table1");
> >>> ...
> >>> $res = mysql_query("SELECT * FROM table2");
> >>> if(!$res)
> >>> return;
> >>>
> >>> $res is still going to be set as a result of your first query.
> >>>
> >>> Use unset($res) between each query.
> >> No, Toby.
> >>
> >> $res will have the results of the second query. The resource returned
> >> by the second query (or false) will overwrite what was in $res.
> >
> > Try that with PDO and it will crash most likely. Overwriting $res will
> > not necessarily free the previous result set, which might then lead to
> > MySQL complaining about an unbuffered query or something like that.
> >
> > | You cannot use the same variable for a PDOStatement object twice. As
> > | others have pointed out it works when you set this variable to null in
> > | between.
> >
> > http://bugs.php.net/bug.php?id=35793
> >
> > Micha
>
> We're not talking PDO , Micha.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

Ok if we need to call, mysql_free_result for mysql resources doesn't
that mean every other type of resources bound this way to a variable
must have a freeing function that has to be called before the variable
can be re-used? So doesn't it coincide with what I am saying that
variables bound to resources when re-used may cause problems. (and
according to the others post the variables can be re-used if the
previously allocated resource is freed)

[Back to original message]