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
