Hello
I was re-reading last mails, analized it carefull again and...
> > 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 ! <--- ***************
I have 2 different result sets, since are two different connections to the
server, simultaneous but independent (two handles, two connections, two
different queries)
Today was probing one of my programs with just one single connection and
mysql_free_result() still crashes even with just one set of results, no
matter how I use it, it always crashes :-(
Any idea?
Regards