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
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
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
Ross
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.
Generally it's a really bad idea to edit primary keys. If you
absolutely must compact the key values, you can do it by
Ross
Apologies for the typo, the snippet for finding the highest id should say
SELECT id FROM tablename ORDER BY id DESC LIMIT 1;
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.16/83 - Release Date: 8/26/2005
--
MySQL
Dear lists members,
I gonna download MySQL and PHP to install on my machine.
But the problem is that I don't know which tarballs are required to
do from mysql.com and php.net.
I mean I would like to manage databases using HTML interface (MySQL/PHP).
Any points or links to the web sites are
-Original Message-
From: Khuon Tech [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 10:10 AM
To: MySQL forum
Subject: Newbee Question !
Dear lists members,
I gonna download MySQL and PHP to install on my machine.
But the problem is that I don't know which
-Original Message-
From: Khuon Tech [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 10:10 AM
To: MySQL forum
Subject: Newbee Question !
Dear lists members,
I gonna download MySQL and PHP to install on my machine.
But the problem is that I don't know which