Newbie - MySQL Question - Finding Unique Names in Column
| From: | Rami Krayem | Date: | Tue, 27 Mar 2001 19:49:09 +0000 |
| Subject: | Newbie - MySQL Question - Finding Unique Names in Column | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-45767@lists.php.net to get a copy of this message | ||
I have a listing of photos in a table as follows (not actual column names):
Image Name, Image Width, Image Height, Band Name, Venue, City, State, Date
I would like to have a list of the different bands with photos in the
archive. There may be 120 photos of any one band, but I would like to
select the name of the band only one time and have it printed in the list.
Is there a MySQL function that would do this, or should I just put the
different bands into a separate table?
Any help would be appreciated.