[miz]

here a way

hmm you can a temp table with auto increment and just
read from old and inset into new 1
then delete old table and recreat it and do the progrees again

way 2 :

PHP Code:

$bla = select * from table name;
$i=0;
while ($bla2 = $DB_site->fetch_array($bla))
{
i++;
$DB_site->query("Upade table Set id='$i' ");
} 


shoudl work
way 2 is better.