sql only return 1 record from the stored proc with php


New Member
I have the following code in php which using to run the stored proc to return the records from the database. \[code\]public function MelHpdlSql02($database){ $connection = mssql_connect("SQL-02", "user", "test"); $db = mssql_select_db($database); return $connection;}public function getRoleRecords(){ $this->MelHpdlSql02("Staff"); $version = mssql_query("EXEC app_role_select"); $row = mssql_fetch_array($version); var_dump($row);die;}\[/code\]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)Does anyone know what is going wrong with my code?