Re: SQL sums

This is an SQL question. James Nunnerley wrote:

I'm trying to create a table, and ultimately a graph, out of some syslog data. I have a mysql table with the following info in it: Time (unixtime stamp), bytes rcvd and bytes sent I want to create a sql statement that group the data over a certain period of time, and produces the following table: Time Sent Rcvd

From x to y

Total bytes sent during period x to y Total bytes rcvd during period x to y

From y to z

Total bytes sent during period y to z Total bytes rcvd during period y to z

From z to a

Total bytes sent during period z to a Total bytes rcvd during period z to a

From a to b

Total bytes sent during period a to b Total bytes rcvd during period a to b Now to create this I've tried a horrible method of using php to call sql table, and then go through each one, and add it to each period of time as appropriate. it's messy and slow! What I want to do is have the mysql do this.is it possible? Cheers Nunners