Sum of All Fields (ok, bad pun)

jimothy

So I've got a Database with one table. And inside that table are 13 fields. 11 of the fields hold numerical data, and the other two are the 'id' fields and the 'datejoined' fields. Now excluding those two fields, I would like to add up all of the numbers in the fields and display them in a HTML table. Now I think I'll have to use a SELECT SUM(table) query... but how do I exclude the datejoined and id fields? Also, I want the data to be displayed as a yearly total, so would I do something like:

WHERE datejoined BETWEEN 'thisyear'

is there even a thisyear variable for timestamps 😉

anyway, I'm hoping that somebody can help me out

thanks in advance

Jim

Wien

I'm not sure about what you want to do but this should do the sum
SELECT SUM(Field1)+SUM(Field2)+...+SUM(Field11) From Table

As for your date problem could you explain more. I guess you want to group your sum by year, so it should be something like

SELECT YEAR(datejoined) as thisYear SUM(Field1)+SUM(Field2)+...+SUM(Field11) From Table GROUP BY thisYear

only if datejoined is a DATE type (or DATETIME)

jimothy

So this is what I have so far:

$connection = mysql_connect($dbhost, $dbusername, $dbpass);
$query = mysql_query("SELECT SUM(aptshopguide)+SUM(aptguide)+SUM(forrent)+SUM(yellowpages)+SUM(driveby)+SUM(wordofmouth)+SUM(resreferral) From week1");
$tresults = mysql_db_query($dbname,$query);
$total = mysql_fetch_object($tresults);

But when I try to display the results by doing

<? echo $total; ?>

All I get is "object" - or if I do mysql_fetch_array, then the result is "array" - so is there a different way to show my results?