PHP & SQL - Sum some value from db

Question

I have table like this

   A   
======
   2
   7
   7
   8
   9
   3
  ...
   1
======

I need to sum all value of row in db, except last value (that is '1'). I know how to sum all value, my question how to sum all value except last value?

$sum = 0;
$a = mysql_query('SELECT A FROM tbl');
while($row = mysql_fetch_array($a))
{
   $jpos = $row['A'];
   $sum     += intval($jpos);
}
echo $sum;

thanks for your response.

SQL servers don't guarantee an order unless you specify with ORDER By. How do you know which should be the last line? — user1864610
– user1864610, Commented Sep 30, 2013 at 0:15
deepak and mike, sory for the mistake, i missed to update the question. i have update it. thanks — Herlambang Permadi
– Herlambang Permadi, Commented Sep 30, 2013 at 0:18
Why don't you let MySQL compute the sum for you? I haven't tested it, but something like this should work: SELECT SUM(A) FROM tbl WHERE id < (SELECT MAX(id) FROM tbl) — n.st
– n.st, Commented Sep 30, 2013 at 0:24

Steven · Accepted Answer · 2013-09-30 00:26:26Z

2

I'm going to make an assumption that the table (tbl) in question will have at least two columns labelled:

id
value

This can be done in mysql:

SELECT SUM(value)
FROM tbl
WHERE id <> (SELECT MAX(id) FROM tbl)

answered Sep 30, 2013 at 0:26

Steven

6,1582 gold badges19 silver badges29 bronze badges

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

Comments

Ezequiel Muns · Accepted Answer · 2013-09-30 00:20:31Z

1

$sum = 0;
$last = 0;
$a = mysql_query('SELECT positif FROM data_aali where id_perusahaan=1');
while($row = mysql_fetch_array($a))
{
   $last = intval($row['positif']);
   $sum += $last;
}
$sum -= $last;
echo $sum;

answered Sep 30, 2013 at 0:20

Ezequiel Muns

7,78035 silver badges59 bronze badges

Collectives™ on Stack Overflow

PHP & SQL - Sum some value from db

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related