Re-number a column sequentially from 1 to ?

It really is this easy!
Use this in your PHP code, or use direct, as sql.


mysql_query('SET @i = 0');
$query = "UPDATE $listsentto SET todo_id=(@i:=@i+1);";
mysql_query($query) OR die(mysql_error());

echo "
Records Updated: ".$raf = mysql_affected_rows();