On Sat, 27 Aug 2005 19:43:57 +0100, [EMAIL PROTECTED] said: > Using mysql with php I have a database that has a unique value for the > user id. when people get delete off the list I want the unique numbers to > compact down so. > > user id 1 > user id 4 > user id 5 > user id 7 > user id 9 > user id 10 > > becomes > > user id 1 > user id 2 > user id 3 > user id 4 > user id 5 > user id 6 > > If this is not possible how can I find the first entry in the database > and last entry with php/mysql?
Not an answer, sorry. But just wondering, you said user id is unique. Is it a primary key? Maybe you should leave it alone, else you're gonna have "trouble"... :^ ) Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]