PHP programming question?

[Friendly_lad]

I need that given two combo boxes where both are getting values from a database. change select one will refresh the other combo box.

For example consider one combo box having all the countries. Another displaying cities . When country selected is china the other combo box will show all cities belonging to china...

All this data is stored in an MS SQL table via ODBC