Ordering lists

[Anthony_john5]

Currently the sms messages and jokes in my content section are only ordered by their unique id number. However I understand how to order them by perhpas date added or number of views. But I also wish to be able to order them by score. Currently the score is worked out by querying the 'totalscore' and 'numberofvotes' and then the totalscore is divided by the number of votes to determine the score. But as the the actual score is not stored in the db, is it possible to order the query by the actual score?

If you don't understand, say so, and I'll do my best to explain further. 🙂

• Anthony

[njm]

Create a defined value in the query, something like:

SELECT id, totalscore, numberofvotes, (totalscore/numberofvotes) AS ave
FROM table
ORDER BY ave;

hth, njm

[Anthony_john5]

Thank-you very much.