leegold wrote:
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.
ORDER BY <unique user id> DESC/ASC LIMIT 1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
