Re: Newbie wants column data without duplication
| From: | Julie Meloni | Date: | Sun, 12 Aug 2001 19:11:39 +0000 |
| Subject: | Re: Newbie wants column data without duplication | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11271@lists.php.net to get a copy of this message | ||
dec> The problem is the tutor group name is duplicated depending upon how
dec> many members it contains. IE If 12 people belong to 7DS then 7DS
dec> appears on the list 12 times. Once would be better.
select distinct field_name from table_name where [whatever]
Julie Meloni
julie@thickbook.com
"PHP Essentials" & "PHP Fast & Easy"
--- www.thickbook.com ---