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
Oh...Yeah I forgot to mention it.
It's Red Hat kernel 2.2.16.
Apache x.x.19. Browser Mozilla/Netscape.
I would like also to verify all users to give their Username/Password to
access my database.
This Computer gonna be both Server for my team project and Client for me.
I mean I'll test and man
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
Oh...Yeah I forgot to mention it.
It's Red Hat kernel 2.2.16.
Apache x.x.19. Browser Mozilla/Netscape.
I would like also to verify all users to give their Username/Password to
access my database.
This Computer gonna be both Server for my team project and Client for me.
I mean I'll test and mana
