dropdown?

Question

when i select country in dropdown1 ... display states in second dropdown  and ...when i select state  ..display disticts in third drop down  and  when i select disticts  display villages in 4 th dropdown 

..............(4dropdown s required)...

using sql tables..

plz write the quarie.......