Re: DATE_SUB Issues

sorry, i press Control+Enter and i send the unfinished mail, here is the continuation: it worked because it was monday, probably today you arent happy. try this sql, but i dont like the GROUP clause SELECT SUM(distance), DATE_FORMAT(time_upload, '%u'), WEEK(time_upload, 1) FROM TRAININGLOG WHERE (WEEK(NOW(), 1) <= WEEK(time_upload, 1)) GROUP BY time_upload LIMIT 1 ----- Original Message ----- From: "Craig Hoffman" <choffman@katomic.com> To: <php-db@lists.php.net> 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 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 - 1946 > e: choffman@eclimb.net > w: www.eclimb.net > _________________________________ > On Mar 29, 2004, at 10:56 AM, Craig Hoffman wrote: > > > 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@eclimb.net > > w: www.eclimb.net > > _________________________________ > > On Mar 29, 2004, at 10:29 AM, John W. Holmes wrote: > > > >> From: "Craig Hoffman" <choffman@katomic.com> > >>> On Mar 29, 2004, at 10:06 AM, John W. Holmes wrote: > >>>> From: "Craig Hoffman" <choffman@katomic.com> > >>>> > >>>>> 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >