Re: re-using variables

From: Toby A Inkster <usenet200702@xxxxxxxxxxxxxxxxx>
Date: Tue, 27 Feb 2007 21:36:47 +0000

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.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!
.

Follow-Ups:
- Re: re-using variables
  - From: Jerry Stuckle

References:
- re-using variables
  - From: Mitesh

Prev by Date: mhash functions for my windows apache development server
Next by Date: Re: mhash functions for my windows apache development server
Previous by thread: Re: re-using variables
Next by thread: Re: re-using variables
Index(es):
- Date
- Thread

Relevant Pages

Re: re-using variables
... $res is still going to be set as a result of your first query. ... Use unsetbetween each query. ... variables bound to resources when re-used may cause problems. ... mysql_free_result, it re-uses what $res is, which is a pointer to a result set, but doing that does *not* free up the space used by the ...
(comp.lang.php)
Re: re-using variables
... $res is still going to be set as a result of your first query. ... Use unsetbetween each query. ... previously allocated resource is freed) ... resources are reference variables unlike other ...
(comp.lang.php)
Re: re-using variables
... $res is still going to be set as a result of your first query. ... Use unsetbetween each query. ... previously allocated resource is freed) ... So my would be question to our guru is can we safely re-use variables ...
(comp.lang.php)
Re: re-using variables
... $res is still going to be set as a result of your first query. ... Use unsetbetween each query. ... variables bound to resources when re-used may cause problems. ... if you re-use $res without a call to ...
(comp.lang.php)
Re: re-using variables
... $res is still going to be set as a result of your first query. ... Use unsetbetween each query. ... Ok if we need to call, mysql_free_result for mysql resources doesn't ... if you re-use $res without a call to ...
(comp.lang.php)