SELECT DISTINCT unit... Ignatius _________________________ ----- Original Message ----- From: <Tristan.Pretty@risk.sungard.com> To: <php-db@lists.php.net> Sent: Thursday, August 07, 2003 3:37 PM Subject: Breaking down a table field.... > I have a table, wth many entries. > Each entry has been asigned a unit to belong to. > > I want to list all the units dynamically. > How can I display all the units, without displaying each instance of the > unit? > > EG: > > Unit item > breakfast cereal > breakfast toast > lunch salad > lunch sandwich > dinner steak > dinner pie > lunch soup > dinner lasagne > > and so on.. > I'd wanna get a list of: > breafast > lunch > dinner > > not several instances of each... > how can I do this? > > ********************************************************************* > The information contained in this e-mail message is intended only for > the personal and confidential use of the recipient(s) named above. > If the reader of this message is not the intended recipient or an agent > responsible for delivering it to the intended recipient, you are hereby > notified that you have received this document in error and that any > review, dissemination, distribution, or copying of this message is > strictly prohibited. If you have received this communication in error, > please notify us immediately by e-mail, and delete the original message. > *********************************************************************** > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
