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

[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

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 sums I'm

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

Re: [PHP] SQL sums

2004-12-03 Thread John Nichel
Marek Kilimajer wrote: This is an SQL question. snip 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:

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

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

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? Use

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 (other

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 list

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

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