Can't get the count value through while loop in sql?

Can't get the count value through while loop in sql?

References

Reference NO 1

http://stackoverflow.com/questions/15195860/cant-get-the-count-value-through-while-loop-in-sql

Reference NO 2

http://stackoverflow.com/questions/17620300/sql-while-loop-getting-stuck-in-infinite-loop

Reference NO 3

http://stackoverflow.com/questions/12290731/iterating-a-select-statement-in-sql-server-2008-using-a-while-loop

Reference NO 4

http://php.net/manual/en/function.mysql-fetch-array.php

Reference NO 5

http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm

Reference NO 6

#EANF#

Reference NO 7

#EANF#

Reference NO 8

#EANF#