Hi! I'm trying to add a new column in my moviedatabase because I want to have a movienumber that doesn't have "holes" between the movies when I delete a movie. So I have to update the new column with increasing numbers. Is it possible to refer to row with a mysqlnumer of any kind? Best regards Richard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php