Re: [PHP] SQL sums

2004-12-04 Thread Marek Kilimajer
Raditha Dissanayake wrote: Marek Kilimajer wrote: Jason Wong wrote: On Saturday 04 December 2004 00:40, Marek Kilimajer wrote: Raditha Dissanayake wrote: Marek Kilimajer wrote: This is an SQL question. Marek, don't you know that this the mysql list? you are supposed to answer questions like these.

Re: [PHP] SQL sums

2004-12-03 Thread Raditha Dissanayake
Marek Kilimajer wrote: Jason Wong wrote: On Saturday 04 December 2004 00:40, Marek Kilimajer wrote: Raditha Dissanayake wrote: Marek Kilimajer wrote: This is an SQL question. Marek, don't you know that this the mysql list? you are supposed to answer questions like these. If you don't there will be

Re: [PHP] SQL sums

2004-12-03 Thread Marek Kilimajer
Jason Wong wrote: On Saturday 04 December 2004 00:40, Marek Kilimajer wrote: Raditha Dissanayake wrote: Marek Kilimajer wrote: This is an SQL question. Marek, don't you know that this the mysql list? you are supposed to answer questions like these. If you don't there will be self appointed list mod

Re: [PHP] SQL sums

2004-12-03 Thread Jason Wong
On Saturday 04 December 2004 00:40, Marek Kilimajer wrote: > Raditha Dissanayake wrote: > > Marek Kilimajer wrote: > >> This is an SQL question. > > > > Marek, don't you know that this the mysql list? you are supposed to > > answer questions like these. If you don't there will be self appointed > >

Re: [PHP] SQL sums

2004-12-03 Thread Richard Lynch
> 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! Yes! To generalize: ANY time you try to get PHP to access SQL data row by row, and do something with it (othe

Re: [PHP] SQL sums

2004-12-03 Thread Greg Donald
On Fri, 3 Dec 2004 14:55:46 -, James Nunnerley <[EMAIL PROTECTED]> 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 Why reinvent the wheel? U

Re: [PHP] SQL sums

2004-12-03 Thread Marek Kilimajer
Raditha Dissanayake wrote: Marek Kilimajer wrote: This is an SQL question. Marek, don't you know that this the mysql list? you are supposed to answer questions like these. If you don't there will be self appointed list moderators who will jump on you like what happened to me last week. I was ac

Re: [PHP] SQL sums

2004-12-03 Thread Raditha Dissanayake
Marek Kilimajer wrote: This is an SQL question. Marek, don't you know that this the mysql list? you are supposed to answer questions like these. If you don't there will be self appointed list moderators who will jump on you like what happened to me last week. I was accused of being not helpfull.

Re: [PHP] SQL sums

2004-12-03 Thread John Nichel
Marek Kilimajer wrote: This is an SQL question. Yes, but this is the php-general_mysql_javascript_wax-my-car_html_apache_kitchen-sink list. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

Re: [PHP] SQL sums

2004-12-03 Thread Marek Kilimajer
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 certa

RE: [PHP] SQL sums

2004-12-03 Thread Thomas S. Crum - AAA Web Solution, Inc.
If someone doesn't give you an answer here, try php cookbook by O'reilly. It has this exact recipe in it. Best, Thomas S. Crum -Original Message- From: James Nunnerley [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 9:56 AM To: [EMAIL PROTECTED] Subject: [PHP] SQL

[PHP] SQL sums

2004-12-03 Thread James Nunnerley
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