Re: PEAR Access Kills While Loop

On Thu, 21 Sep 2006 12:27:24 -0400, brian wrote: > getOne frees the result in $this->db. I suspect that might be your > problem (without seeing more of what's going on. Why don't you just > select status in the first query? This is definitely the problem. Finally, some insight. Thanks! As for doing it seperately the way I have printStatus() will eventually check several other tables, columns, and file_exists. What I included was just a sample to give you an idea. > And if you were to take some of that code out of the class itself you > could simplify it somewhat. In your class, make your query and save the > result into an array (assuming PEAR::MDB2): > > $res =& $db->query("SQL Query Here"); > // fetch each row as an array and stuff it into an array variable Thanks for the idea about the array. I think that will work perfectly. I appreciate your help. /alex