SELECT SUM not working in php code. How do I use it with mysqli

Question

The name of the table is "hit" and the name of the row that i would like the sum of is "amount" but my code is not working

 <?php 
        $result = $mysqli->query('SELECT sum(amount) FROM hits');
        if (FALSE === $result) die("Select sum failed: ".mysqli_error);
        $row = mysqli_fetch_row($result);
        $sum = $row[0];
        print $sum; 

        ?>

The error i get back is "Notice: Use of undefined constant mysqli_error - assumed 'mysqli_error' in ..."

John Conde · Accepted Answer · 2013-05-02 19:58:33Z

1

if (FALSE === $result) die("Select sum failed: ".mysqli_error);

should be

if (FALSE === $result) die("Select sum failed: ".$mysqli->error());

edited May 2, 2013 at 19:58

answered May 2, 2013 at 19:41

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

2 Comments

lin Over a year ago

ahh thank you John Conde. my mistakes are alwaaays obvious and then i feel guilty about making a whole post for it lol! thanks again

Punam Sapkota Over a year ago

@John Conde, I don't see mysqli_error() method exists. Can you paste the link?

Punam Sapkota · Accepted Answer · 2013-05-02 19:48:48Z

0

There is no such mysqli_error() method available in PHP till now. There is mysql_error() you shouln't confuse with it.

The solution is

if (FALSE === $result) die("Select sum failed: " . $mysqli->error);

More MySQLi Error

answered May 2, 2013 at 19:48

Punam Sapkota

1251 silver badge7 bronze badges

3 Comments

lin Over a year ago

Thank you. i did both of your ways and got the same error "Select sum failed: Table 'hits.hits' doesn't exist" i dont have "hits.hits" typed anywhere in my code so im stuck.

Punam Sapkota Over a year ago

What is your database name? Do you configured correctly? $mysqli = mysqli_connect('hostname', 'username', 'password', 'dbname');?

lin Over a year ago

i mixed them up. my database's name is "hits" and the table's name is "hit"... i had the database's name instead of the table's name..! edit: also, thanks for the link.

Collectives™ on Stack Overflow

SELECT SUM not working in php code. How do I use it with mysqli

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related