On Fri, 2 Feb 2001 08:58, Karl J. Stubsjoen wrote:
> When I do this:
> $link = @mysql_pconnect("localhost", $this->db_user_id,
> $this->db_passwd);
>
> And I do this:
> if(!($result = mysql_query($querystr))) { ...
>
> Then I do this:
> $result = DoQuery($q);
>
>
> What objects are there to close? In ASP we issue code like this to close
> these objects:
> rs.close
> set rs = nothing
> db.close
> set db = nothing
> (where rs is the recordset and db is the database)
>
> Thank You!
You don't need to do anything - when the script terminates all that sort of
thing is done for you by PHP. However, if you have a result set that may be
using a bit of memory, and you have a lot more script after the result set
is done with, you can use mysql_free_result. From TFM:
mysql_free_result - Free result memory
Description
int mysql_free_result (int result)
mysql_free_result() will free all memory associated with the
result identifier result.
mysql_free_result() only needs to be called if you are concerned about how
much memory is being used for queries that return large result sets. All
associated result memory is automatically freed at the end of the script's
execution.
For downward compatibility mysql_freeresult() can also be used.
Cheers
--
David Robley | WEBMASTER & Mail List Admin
RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
AusEinet | http://auseinet.flinders.edu.au/
Flinders University, ADELAIDE, SOUTH AUSTRALIA
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
