[development] Ranking in a query

Nikola Kotur kotnick at gmail.com
Fri Oct 29 09:19:17 UTC 2010

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20101029/c7f36059/attachment.html 

More information about the development mailing list