News:

SMF 2.1.6 has been released! Take it for a spin! Read more.

Main Menu

MySQL Question

Started by Minion, August 25, 2003, 02:58:23 PM

Previous topic - Next topic

Minion

Ok.  i have a table with a row that was, lets say, various entries of years.

(2003, 2003, 2002, 2002, 2003, 2003, 2001, 2001, 2001, 2000, 2000,)

Is there a function (or way) that will allow me to select dates from this column where my result would be:

(2003, 2002, 2001, 2000)

I need it for dropdowns.

Thanks.

Jeff Lewis

Don't have the exact code but look up UNIQUE in the mySQL docs (or someone here will post it)
Co-Founder of SMF

Parham

i thought it had to do with DISTINCT...?

Minion


Jeff Lewis

Co-Founder of SMF

Advertisement: