2/16 In PHP, If I loop $result=mysql_query("...SQL here..."); with
a lot of results, while reusing the variable
$result without ever using mysql_free_result($result),
would that make the memory space blow up? Like:
while (1) {
$result=mysql_query("...SQL HERE...");
... use the results in $result ...
// mysql_free_result($result); commented out. Mem blow?
}
\_ Yes. As per the manual, the memory is freed at the end of the
page request.
\_ Consider using Pear DB instead of the mysql functions directly.
It adds a lot of handy shortcut functions, helps abstract your
code away from being mysql-specific, and offers an "autofree"
option. --dbushong |