Freakin' Out - Loop with Conditions

[Bruce]

I'm using Dreamweaver, PHP, MySQL to put together a site. Right, here's the
problem.

I've got a database full of entries (200) of which each entry fits into one
of a selection of Categories (about 10). When I "Repeat" a Category (in a
menu) they all get displayed - which is what I want, but I don't want any of
the Category names to be repeated.

For example:

apple
pear
bannana

and not:

apple
pear
apple
apple
pear
bananna
apple
pear

Does anyone know what I'm talking about?

Regards,

Bruce

[Colin McKinnon]

Bruce wrote:

> apple
> pear
> bannana
>
> and not:
>
> apple
> pear
> apple
> apple
> pear
> bananna
> apple
> pear
>
> Does anyone know what I'm talking about?
>

SELECT DISTINCT fruit FROM stuff;

or

SELECT fruit, count(*) FROM stuff GROUP BY fruit

HTH

C.

[eclipsboi]

Another idea would be using array_unique in PHP.

[url]http://www.php.net/array_unique[/url]

On Fri, 09 Jul 2004 10:36:14 +0100, Colin McKinnon
<colin.deletethis@andthis.mms3.com> wrote:

>Bruce wrote:
>

>> apple
>> pear
>> bannana
>>
>> and not:
>>
>> apple
>> pear
>> apple
>> apple
>> pear
>> bananna
>> apple
>> pear
>>
>> Does anyone know what I'm talking about?
>>

>
>SELECT DISTINCT fruit FROM stuff;
>
>or
>
>SELECT fruit, count(*) FROM stuff GROUP BY fruit
>
>HTH
>
>C.