Single Result From SUM With MySQLi

by

It’s best if you used an alias for your SUM:

SELECT SUM(`field`) as `sum` FROM `table_name`

And then, you’ll be able to fetch the result normally by accessing the first result row’s $row['sum'].

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. How to change mysql to mysqli?
  4. Best way to INSERT many values in mysqli?
  5. Call to a member function bind_param() on a non-object [duplicate]
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. How can I get an unknown username given an ID?
  9. mysqli last insert id
  10. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  11. mysqli_query() expects parameter 1 to be mysqli, object given
  12. MySQLi count(*) always returns 1
  13. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  14. Use one bind_param() with variable number of input vars
  15. Using Mysqli bind_param with date and time columns?
  16. PHP UPDATE prepared statement
  17. Using MySQLi from another class in PHP
  18. SELECT * FROM in MySQLi
  19. MySQLI binding params using call_user_func_array
  20. Mysqli fetch_assoc vs fetch_array
  21. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  22. Is mysqli extension enabled in this php configuration?
  23. php warning: mysqli_close() expects parameter 1 to be mysqli
  24. Getting error mysqli::real_connect(): (HY000/2002): No such file or directory when I try to access my project on live server [duplicate]
  25. Get number of rows matched by UPDATE query with PHP mysqli
  26. How to use mysqli_query() in PHP?
  27. mysqli_fetch_array returning only one result
  28. mysqli persistent connection
  29. Create mysql trigger via PHP?
  30. Cannot figure out how to run a mysqli_multi_query and use the results from the last query

Leave a Comment