#1
  1. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jul 2000
    Posts
    669
    Rep Power
    15
    SELECT DISTINCT datefield from tablename

IMN logo majestic logo threadwatch logo seochat tools logo