I have a query that counts comments and all is well with it. But I'd like add a ranking column to the display. The problem is that it uses tablesort, so the ranking has to be in the query because I don't know which column will be used to sort the display. Oh, it is also paged so I can't count on the first row being #1 and so on.
Has anyone got an idea on how to add a ranking column to the query? (MySql only.) Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
