note 24204 added to function.mysql-fetch-row

does anyone know how i can renumber an entire table? i have a table, set up like this name TEXT, id INT now, if i delete one of the entries, the id list is now messed up, and no longer is in order, how could i loop through all the rows in the table and correctly number them, but i dont want to affect the current order they are in either! I mean, i would like to keep the order its already in. -- http://www.php.net/manual/en/function.mysql-fetch-row.php http://master.php.net/manage/user-notes.php?action=edit+24204 http://master.php.net/manage/user-notes.php?action=delete+24204 http://master.php.net/manage/user-notes.php?action=reject+24204