How does mysql_free_result() work ? how this function works??

[kilz 0]

when I use mysql_free_result() to free the memory. . .seem nothing happened.how if I don't use this function.one more question is. ..mysql_close(). . why should I close mysql connection??

[Hercco 0]

If you don't free your result it will simply stay in the memory until the script execution is over. Basically only thing (other than memory usage) where it matters is that if you happen to have several queries, you can be sure that there are no "ghost" results around. So you will be always processing data from right results. It is good programming style to free your results when you donät need them anymore.I do not know when unclosed database connections get closed automatically (probably depends on PHP configuration), but if it doesn't do it when the script execution ends it might be a security risk. Ie. the connection could be hijacked. Again it is good programmign style to close your database connections when you don't need them. Also if you are doing queries from different databases, closing the connections ensures that you are not doing them from wrong database (ie. using wrong open handle)

[wizzywig 0]

i cant wait to get a data base