Issue with php array_sum displaying multiple values

Question

I'm having an issue with with a PHP function displaying multiple sums instead of just one when I use array_sum. I'm using phpMyAdmin and the two database tables for this function. These are the tables:

games:

enter image description here

cart:

enter image description here

function total_price() {
    $total = 0; 
    global $con; 
    $ip = getIP(); 
    $select_price = "select * from cart where ip_add = '$ip'"; 
    $run_price = mysqli_query ($con, $select_price);
    while ($g_price = mysqli_fetch_array($run_price)) { 
        $Cart_Game_ID = $g_price['g_ID']; 
        $cart_price = "select * from games where Game_ID = '$Cart_Game_ID'";    
        $run_game_price = mysqli_query($con, $cart_price); 
        while($pp_price = mysqli_fetch_array($run_game_price)){
            $Game_Price = array($pp_price['Game_Price']);  
            $values = array_sum($Game_Price);
            $total += $values; 
        }
    echo "$" . $total; 
    }

}

Every game in my database costs $20. There are currently 5 games in my database. When I run this function I get $20$40$60$80$100. All i need is the $100. Not the previous 4 sums.

Is this just for learning purposes? Otherwise, the sum calculation could be done with only one database query, with no loops, ... — php-dev
– php-dev, Commented Mar 12, 2015 at 22:51
Yea its to help understand how loops can be used to pull data from multiple databases. — Aizzle
– Aizzle, Commented Mar 12, 2015 at 23:01

underflow · Accepted Answer · 2015-03-12 22:24:15Z

2

Move this outside the While Loop:

echo "$" . $total;

answered Mar 12, 2015 at 22:24

underflow

4833 silver badges15 bronze badges

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

2 Comments

underflow Over a year ago

Haha your welcome - I know exactly how you feel, all it takes is a fresh pair of eyes

php-dev Over a year ago

@underflow Haha, that's the programmer destiny xD

Collectives™ on Stack Overflow

Issue with php array_sum displaying multiple values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related