from ur code
set @count =(select srno from mous_info where reg_no = @reg_no)+1
make sure 'select srno from mous_info where reg_no = @reg_no' returns single value
if the query returns more than one rows ,u need to correct it.
good luck ;-)
this code may work try
set @count =(select MAX(srno) from mous_info where reg_no = @reg_no)+1