List:General Discussion« Previous MessageNext Message »
From:Miguel Cardenas Date:September 20 2005 4:46am
Subject:Re: mysql_free_result() & 2 different connections
View as plain text  
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
Thread
mysql_free_result() & 2 different connectionsMiguel Cardenas17 Sep
  • Re: mysql_free_result() & 2 different connectionsPooly18 Sep
    • mysql_free_result() CRASHESMiguel Cardenas18 Sep
    • Re: mysql_free_result() & 2 different connectionsMiguel Cardenas20 Sep
      • Re: mysql_free_result() & 2 different connectionsPooly20 Sep
        • Re: mysql_free_result() & 2 different connectionsMiguel Cardenas20 Sep
          • Re: mysql_free_result() & 2 different connectionsPooly20 Sep
            • Re: mysql_free_result() & 2 different connectionsMiguel Cardenas21 Sep
              • Re: mysql_free_result() & 2 different connectionsPooly21 Sep
                • Re: mysql_free_result() & 2 different connectionsMiguel Cardenas22 Sep