quick sum() problem

[jimothy]

Hey, I want to add and print some fields from my table, but only from the newest entry. This is the code I have now:

$query = "SELECT SUM(variable1)+SUM(variable2)+SUM(variable3)+SUM(variable4)+SUM(variable5) from week1 ORDER BY id DESC LIMIT 1"; 

I thought that the "ORDER BY id" would just add 1 row, but for some reason it adds everything in the table... any ideas?

Thanks 🙂

[jimothy]

is it possible that the problem is that the SUM() statements are adding up the rows before the "ORDER BY id DESC LIMIT 1"? And therefore would I have to select which row I want to add before I list the fields??

[Lars_Berg]

You don't need the sum

$query = 
"SELECT  variable1+variable2+variable3+
variable4+variable5 
from week1 
ORDER BY id 
DESC LIMIT 1";

[jimothy]

thanks, it works now 🙂