Column with row number

  • Hello,

    I’m using your plugin to show contest results. Which is very easy and powerfull, terrific job you’ve done !
    I’ve wrote SQL views to sort out the results before display on posts.

    Is there a way to show the row number in a column using your plugin ?

    Thanks for your help,

    Kevin.

Viewing 1 replies (of 1 total)
  • Thread Starter pillek

    (@pillek)

    Hello,

    I’ve actually resolved my issue.

    I’ve created the function “func_inc_var_session()” :

    delimiter //
CREATE FUNCTION <code>func_inc_var_session</code>() RETURNS int
    NO SQL
    NOT DETERMINISTIC
	begin
	  SET @var := IFNULL(@var,0) + 1;
	  return @var;
     end
     //
delimiter ;

    I’ve found it here

    And chained 2 views, one which queries and sorts the data.
    The other that execute the function.
    The second one is displayed in a table on the post and it works perfectly.

    Kevin.

    • This reply was modified 8 years, 2 months ago by pillek.
Viewing 1 replies (of 1 total)
  • The topic ‘Column with row number’ is closed to new replies.