RE: use of mysql_free_result (was Re: [PHP] Efficiency)

if your query is within a loop then it would probably help, e.g. for ($i = 1; $i <= 1000; $i++) { $result = mysql_query("..."); ... } in this case as $result is a resource identifier then reusing it doesn't release the original result. Tim Ward www.chessish.com > -----Original Message----- > From: Support @ Fourthrealm.com [mailto:support@fourthrealm.com] > Sent: 19 September 2002 01:18 > To: php-general@lists.php.net > Subject: use of mysql_free_result (was Re: [PHP] Efficiency) > > > Rick, or anyone, > > Based on what you said below, can you describe for me when the > mysql_free_result tag should be used, and when it is not necessary? > > I'm fluent in other web languages (iHTML, ASP), but am fairly > new to PHP, > so I'm still learning the intricacies of the language, and > the best way to > use it > > Many thanks, > Peter > > > > At 04:02 PM 9/18/2002 -0600, you wrote: > >If you aren't doing anything else in a script, > mysql_free_result is not needed > >in a script like this because the result set will be cleaned > up by PHP when > >the script ends. > > - - - - - - - - - - - - - - - - - - - - - > Fourth Realm Solutions > pbechard@fourthrealm.com > http://www.fourthrealm.com > Tel: 519-739-1652 > - - - - - - - - - - - - - - - - - - - - - > >