Display SQL query results in php

Question

I was trying to calculate the total of each column in the database and display it on the webpage using php. But it just gives me

Array
(
    [0] => 6
    [sum(food1)] => 6
)

which I just want '6' as my result.

Here is my code

for($i=1; $i<=10; $i++){
    $foodid=('food'."$i");
    echo $foodid;
    $food_query = mysql_query("select sum($foodid) from orderdetail where date between '$fm_date' and '$to_date'");
    $ttl_food= mysql_fetch_array($food_query);
    print_r($ttl_food[$i]);
}

Thanks so much!

You need mysql_fetch_row. Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Rikesh
– Rikesh, Commented May 17, 2013 at 10:15

Voitcus · Accepted Answer · 2013-05-17 10:17:41Z

1

The result of SELECT SUM or any other functions like COUNT(), MAX() etc. is always a recordset. You need to just take the first element of the array of rows (even if only one row exists). Just $your_rows_array[0].

To avoid having strange names like [sum(food1)] you can SELECT SUM($foodid) AS mysum FROM ....

answered May 17, 2013 at 10:17

Voitcus

4,4564 gold badges27 silver badges40 bronze badges

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

Comments

Smile · Accepted Answer · 2013-05-17 10:26:52Z

1

Try below one by giving an alias name sumoffood to your aggregate function's output

$food_query = mysql_query("select sum($foodid) as sumoffood from orderdetail where date between '$fm_date' and '$to_date'");

and then use

$ttl_food= mysql_fetch_assoc($food_query);
echo $ttl_food['sumoffood'];

edited May 17, 2013 at 10:26

answered May 17, 2013 at 10:20

Smile

2,7684 gold badges37 silver badges59 bronze badges

Comments

VeNoMiS · Accepted Answer · 2013-05-17 10:16:44Z

0

use

select sum(field) as sum

and

ttl_food['sum'];

answered May 17, 2013 at 10:16

VeNoMiS

3305 silver badges16 bronze badges

Comments

Vijaya Pandey · Accepted Answer · 2013-05-17 11:27:20Z

0

Try this:

for($i=1; $i<=10; $i++){
$foodid=('food'."$i");
echo $foodid;
$food_query = mysql_query("select sum(field) as sum from orderdetail 
where date between '$fm_date' and '$to_date'");
$ttl_food= mysql_fetch_array($food_query);
print_r($ttl_food['sum']);

edited May 17, 2013 at 11:27

answered May 17, 2013 at 10:17

Vijaya Pandey

4,2705 gold badges35 silver badges58 bronze badges

1 Comment

kuldeep.kamboj Over a year ago

You answer is not right. $ttl_food[$i]['sum'] is not right. It must be $ttl_food['sum'].

Collectives™ on Stack Overflow

Display SQL query results in php

4 Answers 4

Comments

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Related