| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Sort by Calculated Values|
Right now I am sorting a table for a query by the contents in a column called "col1".
mysql_query("SELECT * FROM table ORDER BY col1 DESC");
Instead, I would like to calculate a "score" to sort the table by.
score = ((col1-2)*col2)+col3)
Is this possible?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved