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 9 years, 8 months ago by pillek.