nday, March 29, 2004 9:48 PM
Subject: Re: [PHP-DB] DATE_SUB Issues
WooHoo! I got it working!
Basically what I did is I changed this DATE_SUB( NOW(),INTERVAL 7 DAY
) to DATE_SUB( NOW(),INTERVAL 1 DAY ) and it worked. I am not
entirely sure why. Anyone know?
__
C
= WEEK(time_upload, 1))
GROUP BY time_upload
LIMIT 1
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 9:48 PM
Subject: Re: [PHP-DB] DATE_SUB Issues
WooHoo! I got it working!
Basically what I did is I
RAININGLOG
WHERE (WEEK(NOW(), 1) <= WEEK(time_upload, 1))
GROUP BY time_upload
LIMIT 1
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 9:48 PM
Subject: Re: [PHP-DB] DATE_SUB Issues
> WooHoo! I got
oad, '%u'),
> > WEEK(time_upload, 1) FROM TRAININGLOG WHERE DATE_SUB( NOW(),INTERVAL 7
> > DAY ) <= time_upload GROUP BY time_upload LIMIT 1
- Original Message -
From: "Craig Hoffman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
WooHoo! I got it working!
Basically what I did is I changed this DATE_SUB( NOW(),INTERVAL 7 DAY
) to DATE_SUB( NOW(),INTERVAL 1 DAY ) and it worked. I am not
entirely sure why. Anyone know?
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 19
What is should doing is grabbing all entries of this week and return a
total. Its returning the wrong results.
SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'), WEEK(time_upload,
1) FROM TRAININGLOG WHERE DATE_SUB( NOW(),INTERVAL 7 DAY ) <=
time_upload GROUP BY time_upload LIMIT 1
=> Resu
From: "Craig Hoffman" <[EMAIL PROTECTED]>
> still no luck - any other suggestions?
Please define "no luck"
---John Holmes...
> On Mar 29, 2004, at 8:18 AM, John W. Holmes wrote:
> > From: "Craig Hoffman" <[EMAIL PROTECTED]>
> >
> >> Perhaps someone could lend me a hand here on this query. I h
still no luck - any other suggestions?
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
On Mar 29, 2004, at 8:18 AM, John W. Holmes wrote:
From: "Craig Hoffman" <[EMAIL PR
From: "Craig Hoffman" <[EMAIL PROTECTED]>
> Perhaps someone could lend me a hand here on this query. I have a
> query where I would like it to SUM up the last 7 days of records
> further, It needs to start a new week on Monday. The 'time_upload'
> field is a datetime field. What am I doing wron
Hi There,
Perhaps someone could lend me a hand here on this query. I have a
query where I would like it to SUM up the last 7 days of records
further, It needs to start a new week on Monday. The 'time_upload'
field is a datetime field. What am I doing wrong or not doing here ?
SELECT SUM(dist
10 matches
Mail list logo