LIST Split - How to utilise distinct button values

LIST Split - How to utilise distinct button values

I have a MySQL query that brings back several rows of data from the table. I am trying to press the split view delete icon and have that value (database distinct value of 'id') transfer across to the popup dialog to confirm an action and then that in turn sends the id via POST to delete.php

The current code I have put together I can only get the first row's id to work and I cannot figure out what is needed to pass to the popup and delete.php or should I say I don't know how to do it! Still pretty new to this so apologies if it's a complete mess...

Here's my code:

  2. <?php include("auth.php"); ?>
  3. <html>
  4. <head>
  5. <link rel="stylesheet" href="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.css" />
  6. <script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
  7. <script src="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.js"></script>
  8. <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0" />
  9. </head>
  10. <body>
  11. <div data-role="page" id="home">
  12. <div data-role="header" data-theme="a">
  13. <h1>Test</h1>
  14. </div>
  15. <img class="bulge_shadow" src="_/images/bulge_shadow.png" alt="bulge_shadow">
  16. <div data-role="content">
  17. <p class="medium_text">ONLY THE TOP ENTRY WILL WORK AT PRESENT <br><br>Select any inputs you wish to delete</p>

  19. <?php
  20. $db_host = '***';
  21. $db_user = '***';
  22. $db_pwd = '***';

  24. $database = '***';
  25. $table = '***';

  27. if (!mysql_connect($db_host, $db_user, $db_pwd))
  28.    die("Can't connect to database");

  30. if (!mysql_select_db($database))
  31.    die("Can't select database");

  33. $result = mysql_query("SELECT * FROM `***` WHERE username = '$_SESSION[USERNAME]' ORDER BY datestamp DESC LIMIT 15");
  34. if (!$result) {
  35.    die("Query to show fields from table failed");
  36. }
  37. $fields_num = mysql_num_fields($result);
  38. for($i=0; $i<$fields_num; $i++)
  39. {
  40.    $field = mysql_fetch_field($result);
  41. }
  42. while($row = mysql_fetch_row($result))
  43. {
  44. ?> 
  45. <ul data-role="listview" data-inset="true" data-split-theme="a" data-split-icon="delete" data-theme="a" value="<?php echo "$row[0]"?>">
  46. <li><a href="" >
  47. <img src="_/images/chillies/li_<?php echo "$row[3]"?>.jpg"/>
  48. <h3><?php echo "$row[4] x $row[3]"?></h3>
  49. <p><?php echo "$row[1]"?></p>
  50. <a href="#confirm_del" data-rel="popup" data-position-to="window" data-transition="pop">Delete Record</a>
  51. </a>
  52. </li>
  53. </ul>
  54. <div data-role="popup" id="confirm_del" data-theme="a" data-overlay-theme="b" class="ui-content" style="max-width:340px; padding-bottom:2em;">
  55. <form method="post" action="delete.php" name="delrecord" data-ajax="false">
  56. <h3>Delete Record</h3>
  57. <p>Please confirm you wish to delete entry <?php echo "$row[0]"?></p>
  58. <div data-role="fieldcontain">
  59. <input type="hidden" id="id" name="id" value="<?php echo "$row[0]"?>">
  60. <input type="submit" value="Submit" id="submit" data-theme="b">
  61. <a href="#harvest" data-role="button" data-rel="back">Cancel</a>
  62. </div>
  63. </form>
  64. </div>
  66. <?php 
  67. }
  69. mysql_free_result($result)
  70. ?>
  71.            <a href="input.php" rel="external" data-role="button" data-theme="b" data-transition="slide">Done</a>
  72.            <p class="small_text"> Logged in as <?php echo $_SESSION['USERNAME'];?> </p>
  73. </div>
  74. <div data-role="footer" data-position="fixed" data-theme="b">
  75.     <p class="footer_text" >Test App</p>
  76. </div>
  77. </div>
  78. </body>
  79. </html>