Re: re-using variables

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@xxxxxxxxxxxxx
==================
.

Relevant Pages

  • Re: re-using variables
    ... using the $res produces undefined result (sometimes the second query ... or not, not just before a re-use of $res in another query, but also at ... always a good idea to free something you're going to re-use in case your ... This is sometime after the script ends, ...
    (comp.lang.php)
  • Re: re-using variables
    ... $res = mysql_query; ... What I have discovered is re-using the $req variable is fine. ... using the $res produces undefined result (sometimes the second query ... In other words since PHP uses garbage collection re-using the same ...
    (comp.lang.php)