$result = mysql_query("SELECT id, something FROM tablica ORDER BY id"); $i=0; while($fetch = mysql_fetch_array($result, MYSQL_ASSOC)){ $some = $fetch['something']; mysql_query("UPDATE tablica SET id=$i WHERE something = $some") $i += 1; }