Hi,
> while ( my1.fetch ) {
> my2.query + my2.store
> if ( my2.fetch ) {
> report = my1 + my2 results
> } else {
> report = my1
> }
> my2.FreeResult <--- free for every my2.query inside loop
> }
> my1.FreeResult <--- free for unique my1.query
One My2.store == One My2.free.
you're doing it more thant once, it can't work.
from the fine manual :
http://dev.mysql.com/doc/mysql/en/mysql-store-result.html
"You must call mysql_free_result() once you are done with the result set. "
but in you're code you're still using the result set !
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]