how to [Add More..] for thos combobox?

[jrahma]

Hi,

I have the following combobox which populate countries from my database. I want to allow the user to Click a link to Add more of the same combobox so he can add multiple countries.

How can I do this please...

<select name="cboJobLocation" style="width: 100%" required>
    <option value="">[Unspecified..]</option>
    <?php
        $mysql_command = "CALL sp_populate_country()";				
        $mysql_query = $mysql_connection->prepare($mysql_command);

    $mysql_query->execute();

    while($mysql_row = $mysql_query->fetch())
    {
?>
<option value="<?php echo $mysql_row['country_code_alpha2']; ?>" <?php if ($mysql_row['country_code_alpha2'] == $company_country) { echo 'selected'; } ?>><?php echo $mysql_row['country_name']; ?></option>
<?php } ?>
</select>

[sneakyimp]

This question more about client-side technology (i.e., Javascript) than it is about PHP.

For starters, you should probably separate out your PHP code from your HTML code. If you want to create a new <select> tag from all the countries returned by your sp_populate_country function, you'll either need to use that call to define an array in Javascript and create your select's from that array or you'll need to use AJAX to contact your server and request the country list over and over again (which is much less efficient).