Re: Breaking down a table field....
| From: | Ignatius Reilly | Date: | Thu, 07 Aug 2003 14:11:41 +0000 |
| Subject: | Re: Breaking down a table field.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29738@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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.
> ***********************************************************************
>
>