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 > >