Re: mysql_free_result() & 2 different connections

[Pooly]

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/