Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result?

Question

[Jony1337]

Привет
Всё вроде правильно написал но выводит ошибку
Warning: Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0

вот код

<?php
@session_start();
  $tt = $_SESSION['numarul'] ;
 $db = mysql_connect("localhost","a9","T75757545G");
mysql_select_db("ab7",$db);
$resultat = mysql_query("SELECT * FROM `user` WHERE `ids` = $tt",$db);
$data = mysql_fetch_array($resultat);
$mars = time ();
$kaka = $data['tools'];

if ($kaka == 0) {
	$mar = time ();
	$taims= 600; 
	$TimesTWO = $mar + $taims;
$namessUTILIZATOR = $data['numele'] ;
$punteUTILIZATOR = $data['puncte'] ;
$point = rand (1,10);
$poinTfinal= $point + $punteUTILIZATOR;
$registerquery = mysql_query("UPDATE `user` SET `puncte` = $poinTfinal WHERE `ids` = $tt ");
$registerquerysTIME = mysql_query("UPDATE `user` SET `timpul` = $mar WHERE `ids` = $tt "); // timpul cind a fost apasat butonul 
$registerquerysTIME = mysql_query("UPDATE `user` SET `tools` = $TimesTWO WHERE `ids` = $tt "); 

}

else if ($kaka <= $mars) {
	$mar = time ();
	$taims= 600; 
	$TimesTWO = $mar + $taims;
$namessUTILIZATOR = $data['numele'] ;
$punteUTILIZATOR = $data['puncte'] ;
$point = rand (1,10);
$poinTfinal= $point + $punteUTILIZATOR;
$registerquery = mysql_query("UPDATE `user` SET `puncte` = $poinTfinal WHERE `ids` = $tt ");
$registerquerysTIME = mysql_query("UPDATE `user` SET `timpul` = $mar WHERE `ids` = $tt ");
$registerquerysTIME = mysql_query("UPDATE `user` SET `tools` = $TimesTWO WHERE `ids` = $tt "); 
}
else {
	$reZminute = $kaka / 60 ;
	echo "ТЕКСТ " .$reZminute."Minute";
}
 // закрываем соединение с сервером  базы данных
    mysql_close($db);


	

?>

Answer 1

[shagguboy]

фетчить надо всё.
while ($row = mysql_fetch_array($result)) {