<? 

include('db.php'); 

dbQuery("UPDATE pornstars SET `rank` = ''");
$results = dbQuery("SELECT `total_value`, `rating`, `total_votes`, `name`, `record_num`	FROM `pornstars`, `ratings`	WHERE `ratings`.`content` = `pornstars`.`record_num` AND `type` = 1	GROUP BY `pornstars`.`record_num` ORDER BY `pornstars`.`rating` DESC, `total_votes` DESC", false);

$i = 1;
foreach($results as $row) { 
	dbQuery("UPDATE `pornstars` SET `rank` = '$i' WHERE `record_num` = '$row[record_num]'");	
	$i++;
}

$results = dbQuery("SELECT `record_num` FROM `pornstars` WHERE `rank` = ''");
foreach($results as $row) { 
	dbQuery("UPDATE `pornstars` SET `rank` = '$i' WHERE `record_num` = '$row[record_num]'");
	$i++;
}
echo "Done";

?>