When do I need mysql_free_result()?

[Robo]

Do I only need it after the script showed a list of results? Is it necessary to use it after a form submittion?

I have a script like:

if ($id)
{
//update data
$sql = "UPDATE blah...";
}

else
{
//add data
$sql = "INSERT blah...";
}

$result = mysql_query($sql);
echo "<p>Record updated/edited!</p>";


But when I put mysql_free_result ($result) at the end of that, it complains that "Supplied argument is not a valid MySQL result resource"

Is it because I don't need it? Or did I just put that flush memory thing in the wrong place?

[Chris Roane]

Hi,

Well, I have never used that function before and I have been messing with MySQL and PHP a lot the last few months, so I am assuming you don't really need it, but I could be wrong. I know for sure I haven't had any problems from not using it.

Just letting you know from my experience.

Chris Roane

[Son Nguyen]

Unless you do a lot queries (or queries take a lot of memory), you don't really need to free memory from mysql_query
And the syntax is correct though! I don't see why it complained. Could it be MySQL version? I am not sure.