Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. SELECT * FROM event_table JOIN package ON event_id WHERE cusact_id = 8 AND event_id=80
  2.  
  3. $c_id = $_SESSION['u_id'];
  4. $n_id = $_GET['n_id'];
  5. $p_id = $_GET['new_p_id'];
  6.  
  7. <?php
  8. session_start();
  9.  
  10. include_once 'order.confirmation-header.php';
  11.  
  12. include 'includes/dbh.inc.php';
  13.  
  14.  
  15. $c_id = $_SESSION['u_id'];
  16. $n_id = $_GET['n_id'];
  17. $p_id = $_GET['new_p_id'];
  18.  
  19. $sql = "SELECT event_id, event_name, event_date, event_time_start, event_time_end, cusact_id, theme, reserve_date, reserve_time FROM event_table as e INNER JOIN package as p ON e.package_id = p.package_id WHERE cusact_id = $c_id AND event_id=$n_id";
  20. $data = mysqli_query($conn, $sql);
  21.  
  22.  
  23. if(!$data){
  24. echo("Error description: " . mysqli_error($conn));
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement