retrieve values in dropdown box

[rosy]

Hi,
I would like to retrieve values in drop down box from database table.
It should be the date value.
The date is stored as 'yyyy-mm-dd'
I would like to retrieve , yyyy, mm, dd seperately in a drop down box.
Ihow i can make it.
please help
Thanks.

[NogDog]

You could do it directly in your DB query, such as the following (depending on your DBMS and version):

SELECT YEAR(date_col) as year, MONTH(date_col) as month, DAY(date_col) as day FROM table_name WHERE ...etc....

Or you could explode it in your PHP code:

list($year, $month, $day) = explode('-', $date_from_db);