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

btw, this is in MySQL 

--

-----------------
The DevBoard - http://www.thedevboard.com
-----------------
http://www.alladvantage.com/go.asp?refid=BIY971 - AllAdvantage
""Noah Spitzer-Williams"" <noahsw <email protected>> wrote in message
news:8vpimo$fr0$1 <email protected>
> 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>
>

-- 
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>