Bug #17601: Stored Procedure Fetch Array

From: Date: Tue, 04 Jun 2002 21:37:22 +0000
Subject: Bug #17601: Stored Procedure Fetch Array
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-9500@lists.php.net to get a copy of this message
From: dwhitaker@dgsystems.com Operating system: Solaris PHP version: 4.1.2 PHP Bug Type: Sybase-ct (ctlib) related Bug description: Stored Procedure Fetch Array 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 bug report at http://bugs.php.net/?id=17601&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=17601&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=17601&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=17601&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=17601&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=17601&r=support Expected behavior: http://bugs.php.net/fix.php?id=17601&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=17601&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=17601&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=17601&r=globals

« previous php.bugs (#9500) next »