searching data from mysql databas?

I have database in which diiferent kind of records of ... ..

[Knowledge seeker]

I have Mysql database table in which there is a feild name "country" , which is appearing on webpage as drop down menu, and there is another feild "name"
I want to search from the database that user select country name from the dropdown menu and in the other feild manually write the name.

How can I search and display the feilds data from the mysql using the php 4+.

waiting for your comprehensive response.

Thanks in advance.

[rocknbil]

Should be addressed in your other thread I think . . . [webmasterworld.com]

[skinsey]

The question that I would ask of you is. Assuming that we have multiple records with the same country. How will you know which one of the names you select?