On Thu, 2010-10-28 at 06:32 -0700, nan wich wrote: > 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, here's a query that returns a nid, and it's row position: SELECT @row := @row + 1 as row, n.nid FROM node n, (SELECT @row := 0) r; You can start from there.
