if you call a piece of T-SQL (sybase sql) that uses a temporary table - although it only returns one result set - php3 seems to get lost and returns an error of:

1 is not a Sybase result index ... 

a sample piece of sql would be:

################# START SAMPLE ####################

create table #mytable (name varchar(30))
insert into #mytable
select name from sysobjects
select name from #mytable


################# END SAMPLE ####################

a sample piece of php3 would be:
################# START SAMPLE ####################

$dbh = sybase_connect ($server , $user, $password);
$row_handle = sybase_query ($sql , $dbh);

while ($A_row = sybase_fetch_row($row_handle))
{
   print $A_row[0];
}

################# END SAMPLE ####################

although this is a trivial example - you see more sophisticated versions of this quite a lot in Sybase code.

NB: Perl does handle this correctly as does isql so its not an inherent failure in db-library.

NNB it does this in ct-library as well.