Putting database values in a dropdown once

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
reecec
Forum Contributor
Posts: 218
Joined: Sun Apr 02, 2006 7:12 am

Putting database values in a dropdown once

Post 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
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Post by amir »

Try DISTINCT in DB Query
reecec
Forum Contributor
Posts: 218
Joined: Sun Apr 02, 2006 7:12 am

Post by reecec »

Thanks thats what i needed works perfectly

reece
Post Reply