select distinct item from $table
It sounds like you might want to read up a little on normalization, however.
> I would like to modify the following statement
>
> select Item from $table
>
> in such a way that it checks what kinds different items are in the
database. Hence, only those values sh
I would like to modify the following statement
select Item from $table
in such a way that it checks what kinds different items are in the database. Hence,
only those values should be returned, which are not identical to each other. Example:
Apple (5 occurances), Apple-Pie (3 occurances), Pumpk