<?

include_once('connect.php');


$area_sql = mysql_query("SELECT * FROM score3 WHERE ACTIVE=0 LIMIT 1000");

if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){

$mid=$area_row['score_id'];
$Mresult =$area_row['result'];
$Mresults_for =$area_row['results_for'];


mysql_query("INSERT INTO score_new SET result='{$Mresults_for}', results_for='{$Mresult}'");
mysql_query("UPDATE score3 SET ACTIVE=1 WHERE score_id='{$mid}'");  

}

/*

$area_sql = mysql_query("SELECT * FROM score3 WHERE result='{$Mresult}'");

if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){


$result =$area_row['result'];
$results_for =$area_row['results_for'];



//echo "$result : $results_for";
//echo "<hr>";


//active = '0' AND active = '0' AND


mysql_query("INSERT INTO score_new SET result='{$results_for}', results_for='{$result}'");

$counter++;

}
mysql_query("UPDATE score3 SET ACTIVE=1 WHERE result='{$Mresult}'"); 



echo "TOTAL RESULTS: <B>$counter</B>";

$counter = $counter/31;
echo "<HR>PAGE RE-FRESH IN: <B>$counter</B> SECONDS";
echo "<meta http-equiv=\"refresh\" content=\"{$counter}\" />"; 
*/


echo "<meta http-equiv=\"refresh\" content=\"1\" />"; 
ECHO DONE;
 
?>