php sum of an sql query and an php variable

Question

Hey guys i want a sum of an mysql query and an php variable. Is there a function to do this? Here is what i tried:

$result3 = mysql_query($sql3);
                while ($resultarray3 = mysql_fetch_array($result3)){
                $Ergebnis = $Menge + $resultarray['Bestand'];
                echo $Ergebnis;
                }

Can anyone help me on this?

Edit: I want a sum of an php variable and an mysql query not of two sql tables!!!!

What is your sql query? There is a SUM() function in MySQL that may server this purpose more efficiently, depending on how/what you're using. — newfurniturey
– newfurniturey, Commented Dec 3, 2012 at 14:23
@2-Stroker @vodich I was looking for something which does this: $Ergebnis .= $Menge + $resultarray['Bestand']; because when i use my solution $Ergebnis is the same as $menge — Alesfatalis
– Alesfatalis, Commented Dec 3, 2012 at 14:30
I noticed that you use $resultarray['Bestand'] instead of $resultarray3['Bestand'] — v0d1ch
– v0d1ch, Commented Dec 3, 2012 at 14:31

dzgok · Accepted Answer · 2015-03-18 21:55:46Z

1

$menge = '';
$result3 = mysql_query($sql3);
while ($resultarray3 = mysql_fetch_array($result3)){
  $menge = $menge + $resultarray3['Bestand'];
}
// result => $menge

edited Mar 18, 2015 at 21:55

answered Dec 3, 2012 at 14:32

dzgok

263 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

v0d1ch · Accepted Answer · 2012-12-03 14:34:24Z

1

If there is only one row you don't need the .=

$result3 = mysql_query($sql3);
            while ($resultarray3 = mysql_fetch_array($result3)){
            $Ergebnis .= $Menge + $resultarray3['Bestand'];//notice the change on this line
            echo $Ergebnis;
            }

answered Dec 3, 2012 at 14:34

v0d1ch

2,7481 gold badge24 silver badges27 bronze badges

Comments

Hugo Delsing · Accepted Answer · 2012-12-03 14:30:48Z

0

A query to show a result contains SUM(column), so you could use:

$sql3 = "SELECT bestand, SUM(bestand) as menge FROM database GROUP BY bestand";

And then in PHP

$result3 = mysql_query($sql3);
while ($resultarray3 = mysql_fetch_array($result3)){
    echo $resultarray['bestand'] . ' = ' . $resultarray['menge'];
}

answered Dec 3, 2012 at 14:30

Hugo Delsing

14.3k5 gold badges50 silver badges76 bronze badges

1 Comment

Alesfatalis Over a year ago

no i want simply do this: $Ergebnis .= $Menge + $resultarray['Bestand']; and $menge is an php variable

tobiv · Accepted Answer · 2012-12-03 14:39:37Z

0

You define $resultarray3 but then you use $resultarray without the three.

$Ergebnis = $Menge + $resultarray3['Bestand'];

answered Dec 3, 2012 at 14:39

tobiv

8421 gold badge8 silver badges21 bronze badges

Collectives™ on Stack Overflow

php sum of an sql query and an php variable

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related