Sfrgttk

What does "Scientists rise up against statistical significance" mean? (Comment in Nature)

What the heck is gets(stdin) on site coderbyte?

Why didn't Voldemort know what Grindelwald looked like?

What happens if I try to grapple an illusory duplicate from the Mirror Image spell?

How do I fix the group tension caused by my character stealing and possibly killing without provocation?

What should be the ideal length of sentences in a blog post for ease of reading?

Why would five hundred and five be same as one?

Difference between shutdown options

How do I prevent inappropriate ads from appearing in my game?

El Dorado Word Puzzle II: Videogame Edition

How to make a list of partial sums using forEach

Showing mass murder in a kid's book

Do you waste sorcery points if you try to apply metamagic to a spell from a scroll but fail to cast it?

Would this string work as string?

Why do Radio Buttons not fill the entire outer circle?

How many people need to be born every 8 years to sustain population?

Alignment of six matrices

How were servants to the Kaiser of Imperial Germany treated and where may I find more information on them

Why does the Persian emissary display a string of crowned skulls?

Do I have to take mana from my deck or hand when tapping a dual land?

Did I make a mistake by ccing email to boss to others?

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Is there a reason to prefer HFS+ over APFS for disk images in High Sierra and/or Mojave?

Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?

Trying to SUM two seperate columns but not together as part of a search result

In PHP MySQL how to sum or not sum multiple columns?

0

$sql = "SELECT * ,
(SELECT
SUM(value), AS total_value,
SUM(balance) AS total_balance
FROM joblist WHERE value = :total_value AND balance = :total_balance)
FROM joblist
WHERE customer = :customer" ;

$customer = $_POST['customer'];

$statement = $connection->prepare($sql);

$statement->bindParam(':customer', $customer, PDO::PARAM_STR);

$statement->bindValue(':total_value', $total_value, PDO::PARAM_INT);

$statement->bindValue(':total_balance', $total_balance, PDO::PARAM_INT);

$statement->execute();

$result = $statement->fetchAll();

$total_value_result = $statement->fetch_assoc;



$sum = array_sum(array_column($total_value_result, 'total_value_result'));

    echo $sum['total_value'];

} catch(PDOException $error) {
echo $sql . "
" . $error->getMessage();
die();
}

the table is joblist .. columns are work_order,customer,description,value,balance,staus and notes.
I can pull the data into html table but I was needing the sum of the value and balance columns that the search request pulls.

Current code in this screen doesn't work it errors out as I'm trying to accomplish this task.
I'm pulling hair out, but I really shouldn't as I'm no DBA.

thanks for any help.

php

share

asked 4 mins ago

freebsfreebs

1

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

$sql = "SELECT * ,
(SELECT
SUM(value), AS total_value,
SUM(balance) AS total_balance
FROM joblist WHERE value = :total_value AND balance = :total_balance)
FROM joblist
WHERE customer = :customer" ;

$customer = $_POST['customer'];

$statement = $connection->prepare($sql);

$statement->bindParam(':customer', $customer, PDO::PARAM_STR);

$statement->bindValue(':total_value', $total_value, PDO::PARAM_INT);

$statement->bindValue(':total_balance', $total_balance, PDO::PARAM_INT);

$statement->execute();

$result = $statement->fetchAll();

$total_value_result = $statement->fetch_assoc;



$sum = array_sum(array_column($total_value_result, 'total_value_result'));

    echo $sum['total_value'];

} catch(PDOException $error) {
echo $sql . "
" . $error->getMessage();
die();
}

the table is joblist .. columns are work_order,customer,description,value,balance,staus and notes.
I can pull the data into html table but I was needing the sum of the value and balance columns that the search request pulls.

Current code in this screen doesn't work it errors out as I'm trying to accomplish this task.
I'm pulling hair out, but I really shouldn't as I'm no DBA.

thanks for any help.

php

share

asked 4 mins ago

freebsfreebs

1

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

$sql = "SELECT * ,
(SELECT
SUM(value), AS total_value,
SUM(balance) AS total_balance
FROM joblist WHERE value = :total_value AND balance = :total_balance)
FROM joblist
WHERE customer = :customer" ;

$customer = $_POST['customer'];

$statement = $connection->prepare($sql);

$statement->bindParam(':customer', $customer, PDO::PARAM_STR);

$statement->bindValue(':total_value', $total_value, PDO::PARAM_INT);

$statement->bindValue(':total_balance', $total_balance, PDO::PARAM_INT);

$statement->execute();

$result = $statement->fetchAll();

$total_value_result = $statement->fetch_assoc;



$sum = array_sum(array_column($total_value_result, 'total_value_result'));

    echo $sum['total_value'];

} catch(PDOException $error) {
echo $sql . "
" . $error->getMessage();
die();
}

the table is joblist .. columns are work_order,customer,description,value,balance,staus and notes.
I can pull the data into html table but I was needing the sum of the value and balance columns that the search request pulls.

Current code in this screen doesn't work it errors out as I'm trying to accomplish this task.
I'm pulling hair out, but I really shouldn't as I'm no DBA.

thanks for any help.

php

share

asked 4 mins ago

freebsfreebs

1

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$customer = $_POST['customer'];

$statement = $connection->prepare($sql);

$statement->bindParam(':customer', $customer, PDO::PARAM_STR);

$statement->bindValue(':total_value', $total_value, PDO::PARAM_INT);

$statement->bindValue(':total_balance', $total_balance, PDO::PARAM_INT);

$statement->execute();

$result = $statement->fetchAll();

$total_value_result = $statement->fetch_assoc;



$sum = array_sum(array_column($total_value_result, 'total_value_result'));

    echo $sum['total_value'];

share

asked 4 mins ago

freebsfreebs

1

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 4 mins ago

freebsfreebs

1

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

freebsfreebs

1

New contributor

freebs is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

freebsfreebs

1