ALTER PROCEDURE dbo.getsome
        (
        @room varchar(80),
        @lm int,
        @usid int,
        @retxml nvarchar(max) OUTPUT
        )
 
AS
 
SET ANSI_WARNINGS ON
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_PADDING ON
 
 
        SET @retxml =convert(nvarchar(max),( SELECT 
        ((chat.query('(/sroot[1]/message[@id > sql:variable("@lm")])')))  
             FROM mdb WHERE url=@room))
             
        
        RETURN
 
 
///////////////////php code below////////////////
global $$link;
                                $l="";
                                  $stmt=mssql_init("getchat",$$link ); $i=1;
                                mssql_bind($stmt, "@room",    $url,    SQLVARCHAR,    FALSE);
                                mssql_bind($stmt, "@usid",   $usid,    SQLINT4,    FALSE);
                                mssql_bind($stmt, "@lm",  $last,  SQLINT4, FALSE);
                                mssql_bind($stmt, "@retxml", $l,  SQLVARCHAR, TRUE, FALSE,400); 
                                
                                $result = mssql_execute($stmt);