Ohh, Ohhhhhh, OOOOOOHHHHHH! [waving hand wildly in the air] :)
Because primary key should always be system generated and not a value that
the user ever sees, can modify, or that means anything to anyone other than
the system.
usernames can change. PK's should never change.
In this case, if username is to be unique then it would be considered a
Candidate Key. (Would have been the Primary Key if it were not for the
hanging Chads!) :)
Cal
http://www.calevans.com
-----Original Message-----
From: JJeffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 2:14 PM
To: Brandon Feldhahn; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] using ID
What for you need a ID if you have already the username which I guess may a
unique key ?
HTH.
Jayme.
http://www.conex.com.br/jjeffman
-----Mensagem Original-----
De: Brandon Feldhahn <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: segunda-feira, 5 de fevereiro de 2001 22:00
Assunto: [PHP-DB] using ID
> When i make a table with four field (id, name, username, and password)
> what do i do with the i id, how do i make it assign to each password?
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]