Get only a certain td value with JQuery

Get only a certain td value with JQuery

Hi all,

I would like to get a specific td value with JQuery, here it is my code:

  2. $(document).ready(function()
  3. {
  4.    $('table#delTable td a.delete').click(function()
  5.    {
  6.      
  7.        if (confirm("Eliminare il record?"))
  8.        {
  9.         var id = $("#unico").text();
  10.            var data = 'id=' + id;
  11.            var parent = $(this).parent().parent();
  12.  
  13.            $.ajax(
  14.            {
  15.                   type: "POST",
  16.                   url: "Database",
  17.                   data: data,
  18.                   cache: false,
  19.  
  20.                   success: function()
  21.                   {
  22.                    parent.fadeOut('slow', function() {$(this).remove();});
  23.                   }
  24.             });
  25.        }
  26.    });
  27.  
  28.    $('table#delTable tr:odd').css('background',' #FFFFFF');
  29. });
  30. </script>
  31. </head>
  32. <body>
  33. <%
  34. final String selezione = ("SELECT * FROM anagrafica");
  35. ConnectionManager cm = new ConnectionManager();
  36. ResultSet rs = null;
  37. try {
  38. Statement st = (Statement) cm.getConnection().createStatement();
  39. rs = st.executeQuery(selezione);
  40.     out.print("<table align='center' cellpadding='5' cellspacing='0' width='30%' id='delTable' bgcolor='#f6f6f6' style='border:1px solid #cccccc;'>");
  41.     out.print("<tbody><tr>");
  42.     out.print("<th align='left' style='border-bottom:1px solid #cccccc;'><strong>Nome</strong></th>");
  43.     out.print("<th align='center' style='border-bottom:1px solid #cccccc;'><strong>Cognome</strong></th>");
  44.     out.print("<th align='center' style='border-bottom:1px solid #cccccc;'><strong>Elimina</strong></th>");
  45.     out.print("</tr>");
  46. while (rs.next()) {
  47. out.print("<tr id='1' style='background: rgb(255, 255, 255);'>");
  48. out.print("<td align='left'>"+rs.getString("Nome")+ "</td>");
  49.         out.print("<td align='center'>"+rs.getString("Cognome")+ "</td>");
  50.         out.print("<td style = 'display:none' id='unico' align='right'>"+rs.getInt("Id_unico")+ "</td>");
  51.         out.print("<td align='center'><a href='#' class='delete' style='color:#FF0000;'><img alt='' align='absmiddle' border='0' src='delete.png'>"+"</a></td>");
  52.         out.print("</tr>");
  53. }
  54.     out.print("</tbody></table>");
  55. } catch (SQLException sqle) {
  56. sqle.printStackTrace();
  57. } finally{
  58. try {
  59.     if(cm.getConnection()!=null) cm.getConnection().close();
  60.     rs.close();
  61. } catch (SQLException sqle) {
  62. sqle.printStackTrace();
  63. }
  64.   }
  65. %>
The problem is that if my TD has got 3 elements with a unique ID for deleting a record in MySQL Database, and for example the elements in the td (#unico) are 1, 2 and 3 whenever element I click for deleting the first one will disappear, I was wondering if there is a function that when I click the delete icon in the td with the class (delete) it knows what row I'am clicking and get only that ID.

I also tried with $('td#delete').closest('td').text() but in that way I only get (123) all the ID in my TD.

Thank all for your replies.