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]