sql only return 1 record from the stored proc with php
<p>I have the following code in php which using to run the stored proc to return the records from the database. </p>

<pre><code>public function MelHpdlSql02($database)
{
    $connection = mssql_connect("SQL-02", "user", "test");
    $db = mssql_select_db($database);
    return $connection;
}

public function getRoleRecords()
{
    $this-&gt;MelHpdlSql02("Staff");

    $version = mssql_query("EXEC app_role_select");
    $row = mssql_fetch_array($version);     


    var_dump($row);die;

}
</code></pre>

<p>This is only return me the 1 record from the database (which this suppose to have 10 records return when I'm manually running the stored proc)</p>

<p>Does anyone know what is going wrong with my code?</p>
