|
|
Posted by Mitesh on 02/27/07 17:10
Hi all,
I have the following code:
$req = "SELECT * FROM table1";
$res = mysql_query($req);
if(!$res)
return;
while($line = mysql_fetch_array($res))
{
.............
.............
}
$req = "SELECT * FROM table2";
$res = mysql_query($req);
if(!$res)
return;
while($line = mysql_fetch_array($res))
{
.............
.............
}
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. Is the initial
approach of re-using variable wrong if variables contain a
resource(reference type)?
In other words since PHP uses garbage collection re-using the same
variable can cause problems. Is this true?
Navigation:
[Reply to this message]
|