Re: RE: [PHP] Primary Key?

Can you let us know the structure of your Employee table ? Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: Wee Chua <Chua@mail.interclean.com> Para: 'jeremy brand' <jeremy@nirvani.net>; PHP (E-mail) <php-general@lists.php.net>; Php-Db (E-mail) <php-db@lists.php.net>; Php-Db-Help (E-mail) <php-db-help@lists.php.net> Enviada em: terça-feira, 17 de outubro de 2000 17:30 Assunto: [PHP-DB] RE: [PHP] Primary Key? > I don't think you have understand my problem correctly! I want to know the > "value" of the primary key of a recode call John inside the Employee table. > John is the under employee name in my query. > > Employee Table > ID Employeename > 1 John > 2 Mike > > select employeename from employee table > > how would I get the value of primary key of John if I only have employeename > field available on my echo statement? > > -----Original Message----- > From: jeremy brand [mailto:jeremy@nirvani.net] > Sent: Tuesday, October 17, 2000 3:19 PM > To: Wee Chua > Cc: PHP (E-mail); Php-Db (E-mail); Php-Db-Help (E-mail); MySQL (E-mail) > Subject: Re: [PHP] Primary Key? > > > from the mysql monitor: > mysql> desc table_name; > > -jeremy brand > _______________________________________________________________________ > GnuPG Fingerprint: 9F5E 95E0 1CC2 E054 84EA 6099 8ACD 9DBA D2C0 5EA9 > _ http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for > more __ > > On Tue, 17 Oct 2000, Wee Chua wrote: > > > Date: Tue, 17 Oct 2000 15:05:55 -0400 > > From: Wee Chua <Chua@mail.interclean.com> > > To: "PHP (E-mail)" <php-general@lists.php.net>, > "Php-Db (E-mail)" <php-db@lists.php.net>, > "Php-Db-Help (E-mail)" <php-db-help@lists.php.net>, > "MySQL (E-mail)" <mysql@lists.mysql.com> > > Subject: [PHP] Primary Key? > > > > Hi all, > > How could I find out the value of the primary key of a field? What > function > > should I use? For example, I only know the field is John under Employee > > name, how could I find out the primary key of this record in Employee > table? > > Could anyone please help? Thanks in advance for any help! > > > > Calvin > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-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 >