RE: [PHP-DB] using ID

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:jjeffmanweb@conex.com.br] Sent: Wednesday, February 07, 2001 2:14 PM To: Brandon Feldhahn; php-db@lists.php.net 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 <BrandonFeldhahn@earthlink.net> Para: <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net