Posted by Jerry Stuckle on 02/27/07 22:57

Toby A Inkster wrote:
> 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.
>
> Well, obviously.
>
> 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.

But it's still not good programming practice.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]