Title: Column with row number
Last modified: September 13, 2016

---

# Column with row number

 *  [pillek](https://wordpress.org/support/users/pillek/)
 * (@pillek)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/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](https://wordpress.org/support/users/pillek/)
 * (@pillek)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/column-with-row-number/#post-8176995)
 * 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](http://stackoverflow.com/questions/15891993/create-a-view-with-column-num-rows-mysql)
 * 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 9 years, 8 months ago by [pillek](https://wordpress.org/support/users/pillek/).

Viewing 1 replies (of 1 total)

The topic ‘Column with row number’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/tablemaster_d1d7db.svg)
 * [TableMaster](https://wordpress.org/plugins/tablemaster/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablemaster/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablemaster/)
 * [Active Topics](https://wordpress.org/support/plugin/tablemaster/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablemaster/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablemaster/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [pillek](https://wordpress.org/support/users/pillek/)
 * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/column-with-row-number/#post-8176995)
 * Status: not resolved