Hi,

I am using the below code to save the industry to company_industry table (

I wanted to know now how can I populate again the data when editing the company so it will appear in <options> element? I thought of using PHP with just normal loop but I'll still have a problem with the btnAddIndustry and the delete button because only the first cboIndustry will have the add and all others will have the delete button.

this is what I though to have:

2. <?php
3.     $mysql_command = "CALL sp_populate_company_industry(:param_company_guid)";
4.     $mysql_query = $mysql_connection->prepare($mysql_command);
5.     $mysql_query->bindParam(':param_company_guid', $company_guid, PDO::PARAM_STR);
6.     $mysql_query->execute();
7. 
   
8.     while($mysql_row = $mysql_query->fetch())
9.     {
10.          here is the populate code;
11.     }
12. ?>

How can I have this done?

here is my current code for the new company entry:

2. <tr>
3.     <td valign="middle"><?php if (!$_GET["id"]) { ?>Industry<?php } ?></td>
4.     <td valign="middle"><?php if (!$_GET["id"]) { ?>:<?php } ?></td>
5.     <td valign="middle">         
6.         <div id="container">
7.         <select id="cboIndustry" name="cboIndustry[]" style="width: 80%" <?php if (!$_GET["id"]) { ?>required<?php } ?>>
8.             <option value="" selected>[Industry..]</option>
9.             <?php
10.                 $mysql_command = "CALL sp_populate_industry()";
11.                 $mysql_query = $mysql_connection->prepare($mysql_command);
12. 
    
13.                 $mysql_query->execute();
14. 
    
15.                 while($mysql_row = $mysql_query->fetch())
16.                 {
17.             ?>
18.             <option value="<?php echo $mysql_row['industry_id']; ?>"><?php echo $mysql_row['industry_name']; ?></option>
19.             <?php } ?>
20.         </select>
21.         <button id="btnAddIndustry" type="button" style="width:150px">Add More</button>
22.         </div>
23.     </td>
24. </tr>

2. <script type="text/javascript">
3.     $(function() {
4.         var counter = 0;
5.         $('#btnAddIndustry').click(function() {
6.             counter++;
7.             var newField = $('#cboIndustry').clone().
8.                 attr({id: 'cboIndustry_' + counter,
9.                     name: 'cboIndustry[]'});
10.             $('#container').append(newField).
11.             append('<button id="btnDeleteIndustry" type="button" class="delete">Delete</button>');
12.         });
13.         $('#container').on('click', 'button.delete', function()
14.         { $(this).prev().addBack().remove(); });
15.     });
16. </script>