allora farei così
Codice PHP:
$query="select * from tabella";
$result = mysql_query($query);
$i=1;
$j=0;
while($row= mysql_fetch_array($result))
{
$query1="update tabella page=".$i." where id=".$row[id];
mysql_query($query1);
if($j==4)
{
$i++;
$j=0;
}
$j++;
}