Hi, I have a mysql table with columns pts_t2, pts_ext and pts_other which hold each player's point total for that category. I have it displaying player's ranks by ordering by each of those points. However, I would like to have an overall ranking (all categories combined), and I don't want to add another column to just hold a total of these 3 columns. How can I order my select statement to list the players by order of their total points?
Thanks --- Andrew Culver Level 2 DCI Judge Comp Sci 2 at UWO "The frontline is everywhere." --- --------------------------------------------------------------------- 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
