Select Country from second table

[gavenf]

I have a form with a standard text box that i would like to turn into a drop down box that is populated from a mysql table.

How do I change the code of the text box so that it looks at the table and populates the list?

 

Here is the code for the text box

<input type="text" name="country" size="20" maxlength="20">

 

The mysql table has the following fields in it:

 

ccode: where ccode would be AU

Name: where name would be Australia

[Barand]

I prefer to do them as functions, passing the currently selected value as the argument

 

<?php
function countrySelect($current='') 
{
    $sql = "SELECT ccode, name
            FROM country
            ORDER BY name";
    $res = mysql_query($sql);
    $str = "<select name='country'>\n";
    $str .= "<option value='' >- country -</option>\n";
    while (list($cc,$name) = mysql_fetch_row($res)) {
        $sel = $cc==$current ? 'selected' : '';
        $str .= "<option value='$cc' $sel> $name</option>\n";
    }
    $str .= "</select>\n";
    return $str;
}

/**
* to display showing Australia as the selected value
*/

echo countrySelect('AU');
?>

[gavenf]

Do I put the full code into the spot where the text box is meant to go?

Am I supposed to leave the text box there or will this create one?

 

Thanks for the help.