counting different values in different rows, in the same table TOGETHER

[TimTimTimma]

ok,. I made the code belo

$count = $MySQL->Query("SELECT COUNT(T1.hits) AS T1count FROM ".$pre."stats_today AS T1 WHERE (year = '".$Year."') AND (month = '".$Month."') AND (date = '".$Day."')");

$total = (int)mysql_result($count, 0, "T1count");

echo $total;

it counts the total rows it seems. And the total is 24 (for each hour) but what I need it to do is count the total hits for each hour together, I need a grand total for the day adding each hour togather.

[leatherback]

So, what is you rquestion?

[TimTimTimma]

this is the structure

| year | date | month | hits |
+------+------+---------+---------+
| 2005| 9 | 7 | 5000 |
+------+------+---------+---------+
| 2005| 10 | 7 | 4500 |
+------+------+---------+---------+

I need to be able to calculate both the hits from date 9 and 10, in one single sql query