Posted by Toby A Inkster on 02/27/07 21:36

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!

[Back to original message]