Populate a text field after making dropdown menu selection

mukwano · Joined: 10 Jan 2008 Posts: 1

Gurus,

I am a newbie and I need your help.

I have a form where I can list all the countries in the world in a drop down menu - the country list is picked up from the DataBase.

What I want to happen is when a Country is selected, it's corresponding Currency goes in the Currency text field automatically. The drop down works well, but what I can figure out is the next step.

Any suggestions?

I have searched the net for a solution to no avail:

Here below is a bit of the php code:

<?php
$result = @mysql_query("select * from Countries");
if (mysql_num_rows($result) > 0){
print "<select name=\"r_country\">";
while ($row = mysql_fetch_array($result)) {
print "<option value=\"" . $row['Currency'] . "\">" . $row['Country'] . "</option>\n";
}
print "</select>";
}

?>

123ecart · Joined: 13 Jan 2008 Posts: 2

Have you ever used ajax? It seems to work well for this kind of thing.

Barring that, you'll need to write a javascript function.