reorganizar

[Patriarka]

entonces si por que no son muchos datos:

Código PHP:

<?
$conn = mysql_connect($host,$user,$pass) or die ("Error:".mysql_error());
mysql_select_db($db,$conn) or die ("Error:".mysql_error());
$limite = 10;
$sql = "SELECT * FROM noticias order by id DESC LIMIT $limite";
$result = mysql_query($sql,$conn) or die ("Errror:".mysql_error());
$i=1;
while ($row = mysql_fetch_object($result)){
    $update = "UPDATE noticias SET `id` = '$i' WHERE`id` =$row->id;";
    $++;
};
?>