single recordsets from MSSQL

[Anon]

If I know the result of a stored procedure pulls out only one recordset, can I pull this information out without having to perform a loop?

For example: I would like to be able to do something like $id = $result["id"];

This would pull out results from an sp which returns multiple recordsets...

$sql = mssql_init("sp_login", $SQLConn);
mssql_bind($sql, "@", $email, SQLVARCHAR);
mssql_bind($sql, "@pwd", $pwd, SQLVARCHAR);
$result = mssql_execute($sql);

echo(mssql_result());

while($row = mssql_fetch_array($result)) {
echo "<li>" . $row["id"] . " " . $row["name"] . "</li>";
}

(Sorry if the formatting looks pants)

dC

[magicpants]

Please ignore me. I think it's time to go home now.

Code used...

$result = mssql_execute($sql);
$row = mssql_fetch_array($result);
echo($row["id"]);