Capture Same Row HTML Tag Under Table

Capture Same Row HTML Tag Under Table

Hi Guys,

Here's what I have so far.

   
As you can see those were generated with this codes:

  1. <table class="table_format">
  2. <tr id="header_name">
  3. <th>Status</th>
  4. <th>ID</th>
  5. <th>Name</th>
  6. <th>Job Title</th>
  7. <th>Job Code</th>
  8. <th>Cost Ctr</th>
  9. <th>Country</th>
  10. <th>Tower</th>
  11. <th>Team</th>
  12. <th>Hire Date</th>
  13. <th>Email</th>
  14. <th>NT ID</th>
  15. <th>Sup Name</th>
  16. </tr>
  17. <?php
  18. $query = "SELECT * FROM tb_active WHERE sup_name = '$user_id'";
  19. $result = mysqli_query($con, $query);
  21. while($row = mysqli_fetch_assoc($result)) {
  22. $status_nameX = $row["status_name"];
  23. $assoc_id = $row["assoc_id"];
  24. $full_name = $row["full_name"];
  25. $job_title = $row["job_title"];
  26. $job_code = $row["job_code"];
  27. $cost_ctr = $row["cost_ctr"];
  28. $country = $row["country"];
  29. $tower = $row["tower"];
  30. $team = $row["team"];
  31. $rehire_date = $row["rehire_date"];
  32. $email = $row["email"];
  33. $nt_id = $row["nt_id"];
  34. $sup_name = $row["sup_name"];
  36. ?>
  37. <tr class="field_row">
  38. <?php
  39. $query_status_name = "SELECT * FROM tb_status ORDER BY status_name ASC";
  40. $result_status_name = mysqli_query($con, $query_status_name);
  41. ?>
  42. <td>
  43. <select class="status_name_class" style="width:90px">
  44. <option value="<?php echo $status_name;?>" selected="selected"><?php echo $status_nameX;?></option>
  45. <?php
  46. while($row = mysqli_fetch_assoc($result_status_name)) {
  47. $row_id = $row["row_id"];
  48. $status_name = $row["status_name"];
  49. if ($status_name != $status_nameX) {
  50. ?>
  51. <option value="<?php echo $row_id;?>"><?php echo $status_name;?></option>
  52. <?php
  53. }
  54. }
  55. ?>
  56. </select>
  57. </td>
  59. <td><input type="text" value="<?php echo $assoc_id;?>" style="width: 50px" class="assoc_id_class"/></td>
  60. <td><input type="text" value="<?php echo $full_name;?>"style="width: 150px" class="full_name_class"/></td>
  61. <td><input type="text" value="<?php echo $job_title;?>" style="width: 150px" class="job_title_class"/></td>
  62. <td><input type="text" value="<?php echo $job_code;?>" style="width: 90px" class="job_code_class"/></td>
  63. <td><input type="text" value="<?php echo $cost_ctr;?>" style="width: 90px" class="cost_ctr_class"/></td>
  64. <td><input type="text" value="<?php echo $country;?>" style="width: 60px" class="country_class"/></td>
  65. <td><input type="text" value="<?php echo $tower;?>" style="width: 70px" class="tower_class"/></td>
  66. <td><input type="text" value="<?php echo $team;?>" style="width: 220px" class="team_class"/></td>
  67. <td><input type="text" value="<?php echo $rehire_date;?>" style="width: 70px" class="rehire_date_class"/></td>
  68. <td><input type="text" value="<?php echo $email;?>" class="email_class" style="width: 90px"/></td>
  69. <td><input type="text" value="<?php echo $nt_id;?>" style="width: 60px" class="nt_id_class"/></td>
  70. <td><input type="text" value="<?php echo $sup_name;?>" style="width:130px" class="sup_name_class"/></td>
  71. </tr>
  73. <?php
  74. }
  75. ?>
  76. </table>
Bunch of td's on while loop from the database.

What I want to achieve is when I click the drop down box an choose an option I want to grab the ID.

Ex. When I choose row 2 and changed the status to Suspended I want to alert the ID right beside it. 
Output should be "58655"

jQuery so far:
  1. $(".status_name_class").change(function() {
  2. var status_update = $("option:selected", this).text();
  3. var id_assoc = $(".assoc_id_class").val();
  4. alert (id_assoc);
  5. });



Purpose: So I can use AJAX and update the status.