Yes your right - I thought the numbers in the DB were something else.
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
On Apr 2, 2004, at 11:11 AM, Paul DuBois wrote:
At 1
At 10:44 -0600 4/2/04, Craig Hoffman wrote:
Hi there,
I have this query (see below)
SELECT SUM(distance + date), DATE_FORMAT(time_upload, '%M') FROM
traininglog_client, users WHERE username='$username' AND
DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= time_upload AND
users.user_id = traininglog_client
