Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT
- * ,
- (SELECT SUM(value) FROM joblist AS total_value GROUP BY customer AS) V_value,
- (SELECT SUM(balance) FROM joblist AS total_balance GROUP BY customer) AS B_value,
- FROM joblist
- WHERE customer = :customer" ;
- $customer = $_POST['customer'];
- $statement = $connection->prepare($sql);
- $statement->bindParam(':customer', $customer, PDO::PARAM_STR);
- $statement->execute();
- $result = $statement->fetchAll() ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement