sybase_fetch_array Stored Procedure

[Anon]

We are not able to return more than 1 row when calling a Stored Procedure and using sybase_fetch_array

If you we make a a call to the database without Stored Procedures no problem.

PHP 4.1.2
Sybase - CT
Solaris OS

Here's the example code:
$query = sybase_query("EXEC ops_select_mfr @mf_id=$mf_idx",$db);

while ($row = sybase_fetch_array($query)) {
$mfr_recno = $row['mfr_recno'];

}

Any ideas?

[flipis]

Try this:

$query = sybase_query("SELECT id FROM table",$db); //Sample
$rows = sybase_affected_rows($query);

for($i=0;$i<$rows;$i++){

echo "Result number $i --->".$sybase_result($query,$i,"id");

}

Hope it helps

fLIPIS