How to pass parameter into stored proceedure from php

[kris.]

I have a stored Proceedure 'spGetOrderByID' in the sql server.Which gives a record according the given order id.And the stored proceedure is working fine , while i trying in the sql server.This is the php code iam using\[code\]$this->_connectionString = mssql_connect($host, $username, $password) or die("can't connect to server1");$this->_dbName ='databaseName";$selectDB = mssql_select_db($this->_dbName, $this->_connectionString ) or die('Databse error'); $sp = mssql_init('spGetOrderByID', $this->_connectionString);$orderId =824;mssql_bind($sp, "@orderID", $orderId, SQLINT1, false, false);mssql_execute($sp,$this->_dbName);echo $orderId;\[/code\]1: let me know the result of the sored proceedure will be in $orderId, right?2: Do i need to set a any new setting in php, for the stored proceedure to working.But already i can connect the ms sql server successfully3: Now i getting Warning: mssql_execute(): stored procedure execution failedPlease advise me