Sql query to sort catalog items ids out

[Spheral]

Well, ages ago on Ragzezone, someone release a sql code that basically makes all your catalog ids go from 0 etc instead of being all over the place

Does anyone have that? My catalog auto increment is bigger than 93570723 and it starts at 142.
Would be nice to have it consecutive.

[MentaL]

[Late3]

   $arr_query = mysql_query("SELECT * FROM mytable");
   for($i = 1; $i < ($arr_row = mysql_fetch_array($arr_query)); $i++){
      mysql_query("UPDATE mytable SET ID = ".$i." WHERE ID = ".$arr_row['ID']."");
      } 

Something like this?

[Spheral]

Something like this?

Works fine.