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 should be returned, which are not
identical to each other. Example: Apple (5 occurances), Apple-Pie (3
occurances), Pumpkin (8 occurances) should return the list Apple, Apple-Pie,
Pumpkin. How do I do this?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php