reseting result set to go to first row?

[alwa1]

If I get a resultset $result from odbc connection, then I want to get 2 values from the resultset.

so I do:

$id = odbc_result($result, 1); (get 1st col. value)

But now i want the value in the 2nd col. as well... how do i do that?

BTW, this does not work: $name = odbc_result($result,2);
since I have already parsed the row.

So, I want to find a way to position the 'cursor' to the first row again.

Any help very appreciated.

[jblallement]

Hi,

You could use odbc_fetch_into

----- BEGIN PHP ---

if ( odbc_fetch_into( $result, &$row )){
echo $row[1]."\n";
echo $row[2]."\n";
}

----- END PHP ---

Hth