1
Guys,
I am developing a module and in one particular page I need to do 4 or more queries to the database. To do this I use...
$result = $xoopsDB->query("blah");
$row = mysql_fetch_array( $result, MYSQL_BOTH );
...repeated several times. I reuse $result each time because I take the value I need and put it in a seperate variable. The first two queries execute fine. The third however does not execute. The wierd thing is, I get no error, and mysql_errno() and mysql_error() return nothing, implying that either the query never ran, or it ran successfully. But I get nothing back. It's almost as though the line performing the query has just been skipped. I'm almost certain this is a curiosity with the $xoopsDB object (or perhaps the way I am incorrectly using it?!) but It's got me beat.
Any help greatly appreciated.
Thanks, Adam.
PS - If it helps: the first two queries are "SELECT FROM ..." type statements and the third and fourth which don't work are "DELETE FROM ...", so I'm not doing anything with the result on the third and fourth run, just dropping it.