On the control panel of my website I want to create a table with PHP for non-approved user-submitted terms, so that I can approve them depending on if they're not spam or something of the same sort. Only the approved terms will then be shown on the site. To add some nice effects i'm using jQuery. On click of the approved button, I also use its Ajax functions to parse the information to another PHP document which will then execute the SQL query.

Thing is is that only the first approve link works and then when it fades away and is gone, none of the others work anymore. This caused by the lack of unique ID's in the anchor tags. But I have no idea how to give it a unique idea with a variable.. and use that same variable within Ajax.. 

Here is what I have:

1. ... 
2. $query = "SELECT weed_name, your_name, location FROM Weednames WHERE approved = 'no'";
3. $result = mysqli_query($cxn,$query) or die ("Couldn't connect to server. " .mysqli_error($cxn));
5. echo "<table>\n";
6. echo "<tr>\n
7. <td>Weed Nickname</td>\n
8. <td>Name of Submitter</td>\n
9. <td>Location</td>\n
10. <td>Approve?</td>\n
11.  </tr>\n";
12. while($row = mysqli_fetch_assoc($result))
13. {
14. extract($row);
15. echo "<tr id='$weed_name'>\n
16. <td>$weed_name</td>\n
17. <td>by: $your_name</td>\n
18. <td>from: $location</td>\n
19. <td><a href='#' id='approve' name='$weed_name'>Approve</a></td>\n";
20. }
21. echo "</table>\n";
22. ?>
23. <script type="text/javascript">
24. 
    
25. $('#').click(function() {
26.   alert('Handler for .click() called.');
27. });
28. 
    
29. $(document).ready(function(){
30.    
31. $('#approve').click(function() {
32. var weed_name     = $('#approve').attr('name');
33. alert("Weed name: " + weed_name);
35. $.ajax({
36. type: "POST",
37. url: "approve.php",
38. data: "weed_name="+ weed_name,
39. success: function(){
40. $("tr#" + weed_name).fadeOut(); 
41. }
43. });
45. return false;
46. });
47. });
48. </script>

Any suggestions?

Thanks in advance!