date and dropdown link up

Question

i want that if i entered date of any year then in next field which is a dropdown will automaticaly list up entry of that year from sql database table which is already created