Description:
------------
I can't post a short script that creates this problem as  
it appears to be illusive.  
  
I have an DB abstraction class that I have used on  
everysite I have done for the last 3 years and it works on  
every site.  
  
The problem presents itself as an invalid result resource,  
eg.  "8 is not a valid MySQL result resource in  
generic.php line 230"  
  
The code queries a table for 20 "ids", then for each ID it  
loads an object instance variables using a sepearte query,  
then it queries 3 other tables for related info and  
finally prints out a table of info and moves on to the  
next row in the original query.  
  
When it gets to the next row the result resource is no  
longer valid.   
  
The code worked perfectly until the host upgraded, nothing  
has been changed in the last year.  If I download the code  
and run it on my server (PHP 4.3.6) it works perfectly.  
  
Worse still is that other very similar areas of the site,  
using subclasses of the same object code that produces the  
error, work perfectly.  To be clearer, 2 subclasses of a  
ProfileList do very similar things, the both use the same  
code to render themselves.  One fails, the others work.   
even thought they are the same peices of code, the same  
tables and the only difference is in the original query.  
  
The failing query is,   
"SELECT id FROM designers LIMIT 0,20"  
  
I have check again and again that the result is NOT being  
overwritten and it is #8 when the first row is returned  
and is is STILL #8 when the next row is fetched, yet the  
second attempt to fetch returns the invalid result error.  
  
Has the number of active result resources been decreased  
in 4.3.8?  
  
Thanks.