error with mysql_free_result

[KashKurcura]

I have this script that loops through a bunch of queries, I have shown an example below. When i run it I get this error "mysql_free_result(): supplied argument is not a valid MySQL result resource."

How can this be fixed?

$Queries[] = "UPDATE Table SET Status = 'Y'";
    $Queries[] = "DELETE FROM Table WHERE Status = 'N'";


for ($qc=0, $qs=count($Queries);  $qc<$qs;  $qc++) {
	$SQLResult = mysql_query($Queries[$qc], $Connection);
	mysql_free_result($SQLResult);
}
unset($Queries);

[Frederick]

don't use it, you don't need it

[KashKurcura]

I have to use it to free up memory. I need to know how I can use this. Do you or anyone know how?

[tsinka]

You can't use it in this case. UPDATE queries don't return any result sets/result resource so just remove it. If you have any memory problems then the cause for that must be somewhere else.

The manual contains a lists of query types that return a resource.

Thomas

[KashKurcura]

ah ok thanks! i have select queries that this will work on. ;-)