[PHP-DB] ? Sort by a summation of columns ? From: Noah Spitzer-Williams (noahsw <email protected>)
Date: 11/25/00

I have a database setup as follows:

some fields... | v1 | v2 | v3 | v4 | v5
some fields... | v1 | v2 | v3 | v4 | v5
some fields... | v1 | v2 | v3 | v4 | v5

how can i retrieve a list of these rows sorted by the sum of v1 + v2 + v3 +
v4 + v5?

for instance, can i do like : ORDER BY sum(v1,v2,v3,v4,v5)?

- Noah

-- Thanks!

-----------------
The DevBoard - http://www.thedevboard.com
-----------------
http://www.alladvantage.com/go.asp?refid=BIY971 - AllAdvantage 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>