Accessing Stored Procedure in PHP
===

I am running sql server 2008, and have all the required driver etc. And I am successfully able to run a simple query. I am now trying to run a stored procedure, and having alot of difficulty. This is the current simple query I have running.

            <?php
        $c = new PDO("sqlsrv:Server=localhost;Database=SMWU_424", "username", "password");
        $c->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        $c->setAttribute( PDO::SQLSRV_ATTR_QUERY_TIMEOUT, 1 );
        
         $query = ' SELECT [lx_loc_nbr]      ,
             [lx_loc_code]      ,
             [lx_loc_name]  FROM [SMWU_424].[dbo].[local_x]WHERE [ActiveInternal]=1';

         $stmt = $c->query( $query );
         while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ){
             print_r( $row['lx_loc_nbr'] ."\n" );
             print_r( $row['lx_loc_code'] ."\n" );
             print_r( $row['lx_loc_name'] ."\n" );
             echo "<br>";
             }


        ?>

I wan't to run the stored procedure: exec usp_getBAs

could anyone give me the code to do this, as really. I have tried nearly every tutorial to no avail! thanks