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.user_id GROUP BY username
and it returns this: (see below)
SUM( distance + date ) DATE_FORMAT( time_upload, '%M' ) 140282467.4 March
How can I make the 140282467.4 into a more "readable" number? Such as 14.54.
My distance field in MySQL is a double, if that helps.
__________________________________ Craig Hoffman - eClimb Media
v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
