RE: [PHP] Subtotal

2003-03-19 Thread Mike Smith
tamps. -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:37 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Subtotal Umm, add: SUM([rushqty]) AS 'rushsub' To your select, wouldn't that work? On Wed, 2003-03-19

RE: [PHP] Subtotal

2003-03-19 Thread Adam Voigt
ay, March 19, 2003 8:19 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Subtotal SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: >I'm trying to present a simple SELECT statement &q

RE: [PHP] Subtotal

2003-03-19 Thread Mike Smith
Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:19 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Subtotal SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: >I'm tryin

Re: [PHP] Subtotal

2003-03-19 Thread Marek Kilimajer
SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: I'm trying to present a simple SELECT statement "GROUPED" by date. Ex. WOUNITSOEMCOMMENTSDATE 123 10MeNotes03/18/2003 456 5

[PHP] Subtotal

2003-03-18 Thread Mike Smith
I'm trying to present a simple SELECT statement "GROUPED" by date. Ex. WOUNITSOEMCOMMENTSDATE 123 10MeNotes03/18/2003 456 5 You More Notes 03/18/2003 Total 15 ... I have it working grouping the da