get output from Stored Procedure

Hello How are you
I want to get a value as output from Stored Procedure in Microsoft SQL Server but I can't

my Stored Procedure code:

Code:

ALTER PROCEDURE [dbo].[count_message]
        @username smallint
    
    
AS    SET NOCOUNT ON;

     
 

return  isnull((select count(*) from dbo.sd_message where ms_user=1 or ms_user=@username),0)

my PHP/Codeingiter Code:

PHP Code:

$result = $this->db->query("update_message '2300'");
echo 'resutl:'.$result;