iain furneaux writes:
> yes after every call, that was the first thing I tried, it made the
> situation better but not cured it. Are there any circumstances where
> mysql_free_result() will not free the result ? does it have to be called
> before any further mysql_real_query() calls are made even on a diffrent
> MYSQL_RES pointer ?
>
> I think I am heading for a code re-write by the looks of things so any
> suggestions on common traps that I may have fallen into would be helpful
>
> thanks
>
No, mysql_free_result() will always free memory allocated by
mysql_use_result, mysql_store_result, fetch_row() etc ...
If you wish to have several MYSQL_RES, you may, but each should be
tied to a separate MYSQL structure.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
