Hi, I have a table with multiple instances of username (Basically a table of dial-in user's input/output octets). What I want to do (In Perl), was to select each username (And associated in/out octets), add them together, and finally print out a total for each user. eg. Username InOctets OutOctets testuser 134838230 1287123474 testuser2 123448 2882779871 I can currently do a query (search) on a particular username, but not search through the whole table and give me a grand total on all users. Any ideas/suggestions are greatly appreciated, Regards, MB --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
