Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2.  
  3. if (isset($_POST['submit'])) {
  4.  
  5. echo $_POST['account'];
  6. }
  7.  
  8. ?>
  9.  
  10. <form action="" method="POST">
  11. <select id="account" name="account">
  12. <option value="1">Tes1</option>
  13. <option value="2">Tes2</option>
  14. </select>
  15. <input type="submit" name="submit"/>
  16. </form>
  17.  
  18. <?php
  19. if (isset($_REQUEST['save'])) {
  20. $sql = "SELECT Business_Unit, COUNT(Joining_Month) AS 'A' FROM jl WHERE Business_Unit = '".$_REQUEST['opt']."' GROUP BY Business_Unit";
  21.  
  22. // Here is your sql query
  23. echo $sql;exit();
  24. }
  25. ?>
  26.  
  27. <form method="post" action="">
  28. <select name="opt">
  29. <option value="1">Option 1</option>
  30. <option value="2">Option 2</option>
  31. <option value="3">Option 3</option>
  32. <option value="4">Option 4</option>
  33. </select>
  34.  
  35. <input type="submit" name="save" />
  36. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement