List:General Discussion« Previous MessageNext Message »
From:Pooly Date:September 18 2005 12:52pm
Subject:Re: mysql_free_result() & 2 different connections
View as plain text  
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/
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