Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. $sql = "SELECT
  2. * ,
  3. (SELECT SUM(value) FROM joblist AS total_value GROUP BY customer AS) V_value,
  4. (SELECT SUM(balance) FROM joblist AS total_balance GROUP BY customer) AS B_value,
  5. FROM joblist
  6. WHERE customer = :customer" ;
  7.  
  8. $customer = $_POST['customer'];
  9. $statement = $connection->prepare($sql);
  10. $statement->bindParam(':customer', $customer, PDO::PARAM_STR);
  11. $statement->execute();
  12. $result = $statement->fetchAll() ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement