Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username = 'nmarp';
- $password = '';
- mysql_connect('localhost',$username,$password);
- mysql_select_db('nmarp');
- $query = "SELECT purchasePrice
- FROM code
- WHERE id
- IN (SELECT DISTINCT codeId FROM codeValidationChangelog
- WHERE status = 'Closed: Check Approved')";
- $result = mysql_query($query);
- $total = 0;
- while ($row = mysql_fetch_array($result)) {
- $purchasePrice = (float)$row['purchasePrice'];
- $purchasePrice = trim($purchasePrice);
- $purchasePrice = sprintf('%.2f', $purchasePrice);
- $total += $purchasePrice;
- }
- echo $total . PHP_EOL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement