Re: DATE_SUB Issues

[Craig Hoffman <choffman@xxxxxxxxxxx>]

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

=> Results: (This is wrong)
=> Weekly Miles: (Week starts on Monday)  5.34

Correct Results should be this:
Weekly Miles:   30.5
__________________________________
Craig Hoffman - eClimb Media

v: (847) 644 - 8914
f: (847) 866 - 1946
e: choffman@xxxxxxxxxx
w: www.eclimb.net
_________________________________
On Mar 29, 2004, at 10:29 AM, John W. Holmes wrote:

> From: "Craig Hoffman" <choffman@xxxxxxxxxxx>
> > On Mar 29, 2004, at 10:06 AM, John W. Holmes wrote:
> > > From: "Craig Hoffman" <choffman@xxxxxxxxxxx>
> > >
> > > > still no luck - any other suggestions?
> > >
> > > Please define "no luck"
> >
> > Yes of course.   Here is my new query.
> >
> >   SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'),
> > WEEK(time_upload, '7') FROM TRAININGLOG WHERE DATE_SUB( NOW(),INTERVAL
> > 7 DAY ) <= time_upload GROUP BY time_upload LIMIT 1
>
> So how does it not work? What are you expecting? What is returned? Is 
> an
> error occuring or the wrong results or no results??
>
> ---John Holmes...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php