|
Posted by Jerry Stuckle on 02/28/07 02:43
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
==================
Navigation:
[Reply to this message]
|