Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.32 KB | None | 0 0
  1. <div class="jumbotron">
  2. <div class="row">
  3. <div class="col-md-6 ">
  4. <?php
  5. $query = "SELECT ppu FROM medicion";
  6. $resultados = mysqli_query($enlace, $query);
  7. ?>
  8. <select class="form-control">
  9. <option>PPU</option>
  10. <?php
  11.  
  12. while ($resultado = mysqli_fetch_assoc($resultados)) {
  13. echo "<option value=".$resultado['id'].">".$resultado['ppu']."</option>";
  14. } ?>
  15. </select>
  16. </div>
  17. <div class="col-md-6 ">
  18. <select class="form-control">
  19. <option>Normal select</option>
  20. </select>
  21. </div>
  22. </div>
  23. </div>
  24.  
  25. <div class="jumbotron">
  26. <div class="row">
  27. <div class="col-md-6 ">
  28. <?php
  29. // aquí añadimos el DISTINCT
  30. $query = "SELECT DISTINCT ppu FROM medicion";
  31. $resultados = mysqli_query($enlace, $query);
  32. ?>
  33. <select class="form-control">
  34. <option>PPU</option>
  35. <?php
  36.  
  37. while ($resultado = mysqli_fetch_assoc($resultados)) {
  38. echo "<option value=".$resultado['id'].">".$resultado['ppu']."</option>";
  39. } ?>
  40. </select>
  41. </div>
  42. <div class="col-md-6 ">
  43. <select class="form-control">
  44. <option>Normal select</option>
  45. </select>
  46. </div>
  47. </div>
  48. </div>
  49.  
  50. <div class="jumbotron">
  51. <div class="row">
  52. <div class="col-md-6 ">
  53. <?php
  54. // aquí añadimos el GROUP BY
  55. $query = "SELECT ppu FROM medicion GROUP BY ppu";
  56. $resultados = mysqli_query($enlace, $query);
  57. ?>
  58. <select class="form-control">
  59. <option>PPU</option>
  60. <?php
  61.  
  62. while ($resultado = mysqli_fetch_assoc($resultados)) {
  63. echo "<option value=".$resultado['id'].">".$resultado['ppu']."</option>";
  64. } ?>
  65. </select>
  66. </div>
  67. <div class="col-md-6 ">
  68. <select class="form-control">
  69. <option>Normal select</option>
  70. </select>
  71. </div>
  72. </div>
  73. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement