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 Ge
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 al
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
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
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
I
t;
> Hope it helps - Jim
>
> > -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,
You didn't say which operating system you are using, but I take it is
a Unix type. I had a programmer install mysql on a Redhat Linux 6.2
system, but I ran into significant bugs while attempting to install
php. I wanted to get phpMyAdmin installed, because myODBC proved
seriously unreliable fo
t;
> Hope it helps - Jim
>
> > -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,
&g
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 high
