<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY>
On Thu, 2010-10-28 at 06:32 -0700, nan wich wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
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.) <BR>
</BLOCKQUOTE>
<BR>
Nancy, here's a query that returns a nid, and it's row position:<BR>
<BR>
SELECT @row := @row + 1 as row, n.nid FROM node n, (SELECT @row := 0) r;<BR>
<BR>
You can start from there.<BR>
<BR>
</BODY>
</HTML>