Hi,

I have employee evaluation for and it's populating the data from database and for every element of the evaluation there is a <select> to choose the employee rating.

I want to know how can I implement this? I need to show the first question and when the user selects from the dropdown then only it will show the next question until last? How to name the <select>? will all have same name?

here is my code:

1. <table data-role="table" id="movie-table" data-mode="reflow" class="ui-body-d ui-shadow table-stripe ui-responsive">
2. <thead>
3. <tr>
4.     <th data-priority="1"></th>
5.     <th data-priority="2"></th>
6. </tr>
7. </thead>
8. <tbody>
9. <?php
10. // get leave details;
11. $mysql_query = $mysql_connection->prepare('CALL sp_web_get_employee_evaluation_elements_by_guid(:param_employee_evaluation_guid)');
12. $mysql_query->bindParam(':param_employee_evaluation_guid', $evaluation_guid, PDO::PARAM_STR);
13. 
    
14. $mysql_query->execute();
15. 
    
16. if ($mysql_query->rowCount() <= 0)
17. {
18. exit(header("Location: index.php"));
19. }
20. 
    
21. while($mysql_row = $mysql_query->fetch()) {
22. ?>
23. <tr>
24.     <td style="padding: 10px;"><b>ID:</b></td>
25.     <td style="padding: 10px;"><?php echo $mysql_row["employee_evaluation_details_id"]; ?></td>
26. </tr>
27. <tr>
28.     <td style="padding: 10px;"><b>Element</b></td>
29.     <td style="padding: 10px;"><?php echo $mysql_row["employee_evaluation_element_name"]; ?></td>
30. </tr>
31. <tr>
32.     <td style="padding: 10px;"><b>Rating :</b></td>
33.     <td style="padding: 10px;">
34.         &lt;select name="cboRating" id="cboRating" data-native-menu="false" required>
35.             &lt;option value="">[Select..]&lt;/option>
36.             <?php
37.               $mysql_rating_category_command = "CALL sp_web_populate_evaluation_rating_category()";
38.               $mysql_rating_category_query = $mysql_second_connection->prepare($mysql_rating_category_command);
39.               $mysql_rating_category_query->execute();
40.             
41.               while($mysql_rating_category_row = $mysql_rating_category_query->fetch())
42.               {
43.             ?>
44.             &lt;option value="<?php echo $mysql_rating_category_row["evaluation_rating_category_id"]; ?>"><?php echo $mysql_rating_category_row["evaluation_rating_category_name"]; ?>&lt;/option>
45.             <?php } ?>
46.         &lt;/select>
47.     </td>
48. </tr>
49. <?php } ?>
50. </tbody>
51. </table>

Thanks,

Jassim