Re: Getting totals from database

2001-01-27 Thread pferraro
Eric, Thank you for the information! It works fine! I did go to the page below, but it was for Mathematical EQUATIONS, like syne,radius, circum, etc... I looked under all of those pages and never really saw and reference to simply pulling totals out. I really appreciate it! It wor

Re: Getting totals from database

2001-01-26 Thread Eric Fitzgerald
http://www.mysql.com/doc/M/a/Mathematical_functions.html Please please please read manual before asking questions. SELECT SUM(minutes) AS ttltime, user FROM table WHERE user = 'someuser' GROUP BY user - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, J