Mysqli_Free_Result Warning

[davidannis]

I am trying to be a good coder and free the mysqli result set after I no longer need it, but I get a Warning:

 

Here is the code:

			    $query="INSERT INTO `".DATABASE."`.`competitors` (`company_id`, `competitor_id`, `name`, `description`, `print_order`, `buildfrom`) ".
				    "VALUES ('".$company_id."', NULL, '".$name."', '".$description."', '', '')";
			    $result=mysqli_query($link,$query) or die ("FAILED to insert into competitor table");
			    mysqli_free_result($result);

 

and I get the following warning:

 

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /usr/local/zend/apache2/htdocs/NewFolder/Overview/competitors2.php on line 25

 

Is the reason that I I am trying to free a result set after an insert instead of after a SELECT?

[kicken]

Is the reason that I I am trying to free a result set after an insert instead of after a SELECT?

 

Yes, an INSERT does not return a result set, so there is nothing to free.  INSERT just returns a true/false indicating if the query ran successfully or not.