|
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!
Navigation:
[Reply to this message]
|