MySQLi column sum working for one query but not another

Question

I am trying to sum the total value of one column....

I have it working for doing sum of other columns, yet this colum wont sum and I don't get a value echo'd.

Anyone have any suggestions why, the formatting of the colum return is the exact same as profit (decimal 5,2)

PHP - Working one

 <div class="col-md-2 col-md-2-2">
                    <div class="card mt-5">
                        <div class-title>
                        <h3 role="button" class="bg-secondary text-white text- 
   center py-3">Stake Placed<br></h3>                           
                        </div>
                        <div class="card-body">
    <table class='table table-bordered'>
    <?php

    $connection = mysqli_connect("******", "******", 
    "******", "******");
    if (!$connection) {
        die("Database connection failed: " . mysqli_connect_error());
    }

             $Date = '2019-03-11'; 

    $ssql="SELECT sum(stakePlaced) as total FROM bets WHERE betDate = '$Date'";


    $sresult = mysqli_query($connection, $ssql);

    while ($srow = mysqli_fetch_assoc($sresult))
    { 
    echo "<tr>";
    echo "<td class='text-center'>£".$srow['total'] . "</td>";
    echo "</tr>";
    }

    mysqli_close($connection);
    ?>
    </table>
                        </div>


                    </div>
                </div>

PHP - Not Working one

            <div class="col-md-2 col-md-2-2">
                    <div class="card mt-5">
                        <div class-title>
                        <h3 role="button" class="bg-secondary text-white text- 
    center py-3">Actual Return<br></h3>                         
                        </div>
                        <div class="card-body">
    <table class='table table-bordered'>
    <?php

    $connection = mysqli_connect("******", "******", 
    "******", "******");
    if (!$connection) {
        die("Database connection failed: " . mysqli_connect_error());
    }

             $Date = '2019-03-11'; 

    $test = "SELECT sum(return) as total FROM bets WHERE betDate = '$Date'";

    $testr = mysqli_query($connection, $test);

    while ($testrow = mysqli_fetch_assoc($testr)) 

    { 
    echo "<tr>";
    echo "<td class='text-center'>£".$testrow['total'] . "</td>";
    echo "</tr>";
    }

    mysqli_close($connection);
    ?>
    </table>

result screenshot table screenshot

Not sure but I guess `return` is a reserved mysql keyword..change the name or add quotes — B001ᛦ, Mar 08 '19 at 12:38
If that is the problem, is there a way round, as I have forms, php-edit forms etc relying on that column being named return — George Richardson, Mar 08 '19 at 12:39
_If that is the problem, is there a way round..._ Have you read my first comment completely? — B001ᛦ, Mar 08 '19 at 12:39

score 0 · Answer 1 · edited Mar 08 '19 at 12:57

0

return is reserved keyword in mysql. Either change the column name or you should use ticks when using that column name

sum(`return`)

edited Mar 08 '19 at 12:57

Qirel

25,449
7
45
62

answered Mar 08 '19 at 12:45

kami s

11
4

MySQLi column sum working for one query but not another

1 Answers1