Posted by Michael Fesser on 02/28/07 02:13

..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

[Back to original message]