Bug #17601 Updated: Stored Procedure Fetch Array

ID: 17601 Updated by: james.downie@visy.com.au Reported By: dwhitaker@dgsystems.com Status: Open Bug Type: Sybase-ct (ctlib) related Operating System: Solaris PHP Version: 4.1.2 New Comment: Try using sybase_fetch_row, but have to refer to the fields by numeric cell references. Previous Comments: ------------------------------------------------------------------------ [2002-06-04 17:37:22] dwhitaker@dgsystems.com PHP 4.1.2 Solaris Sybase We are not able to return more than one row when doing a sybase_fetch_array on a stored procedure. Here is an example of my code: $query = sybase_query("EXEC ops_select_mfr @mf_id=$mf_idx",$db); while ($row = sybase_fetch_array($query)) { $mf_id = $row['mf_id']; $display .= "<tr><td>$mf_id</td></tr>"; } This is echoed in a table, of course. The first row is returned but nothing else. We have checked our data using SQL Advantage so there are multiple rows. Does sybase_fetch_array work correctly? If so what are we doing wrong? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17601&edit=1