Re: Assistance Urgent.

To get the options: $sql = "SELECT DISTINCT related_discipline FROM <your_table> ORDER BY options"; To get the total number of options: $sql = "SELECT COUNT(related_discipline) FROM <your_table>"; To get the number of entries for each option 'RAIL' for example: $sql = "SELECT COUNT(related_discipline) FROM <your_table> WHERE related_discipline='RAIL' ORDER BY related_discipline"; That should do it. Russ On Wed, 12 Dec 2001 10:06:04 EST Bzdpltd@aol.com wrote: > Hi I am new to this list and need some help with PHP and MYSQL. > > We have a database that has lots of fields in the table. What we are trying to do is get > specific > results, i will explain. > > Basicall we need to be able to retrieve the total number of records in the database but for > individual entries. > > We have a field named: related_discipline which contains 1 of 12 different disciplines. So for > example we have Rail which could be in the field, or Utilities and so on.. what we need to do > is > know how many of each there are in the database, I am still developing my knowledge of PHP and > MySql so help would be appreciated. We need to be able to display the 12 different options that > > could be in that field in the database and how many entries there are for each option. > > I would truly appreciate if someone could assist me here. > > With kindest regards > > > Barry Zimmerman > > -- > 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 > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------#