November 21st, 2000, 12:55 PM
I have a MySQL table which is holding my photo gallery. Each photo has an ID number and a date. There are lots of photos taken each day (ie 24th, 24th, 24th etc..). I want to have a drop-down menu that says, "See photos from a particular day" and lists the days, but the problem is, for the days where there are more than one photo taken, I only want that day listed once, not once for each photo taken. Any ideas?
November 21st, 2000, 01:05 PM
SELECT DISTINCT datefield from tablename