Page 1 of 1

Putting database values in a dropdown once

Posted: Sun Oct 22, 2006 8:04 am
by reecec
hi,

is the anyposible way that when i fetch the dates from my dates fields that it puts them in a drop down but only once

eg.


there will be lots of the same month like

OCTOBER 2006
OCTOBER 2006
OCTOBER 2006
OCTOBER 2006
OCTOBER 2006
OCTOBER 2006


how do i put the month in only once

i know how to use fetch field and put it into a loop for a dropdown but not only once


thanks reece

Posted: Sun Oct 22, 2006 8:26 am
by amir
Try DISTINCT in DB Query

Posted: Sun Oct 22, 2006 1:13 pm
by reecec
Thanks thats what i needed works perfectly

reece