how do you get number of rows from odbc?

[Anon]

I would like to know how to get the number of rows returned by by an odbc connection. Unfortunately I get a -1 for the following code.

<?
$db = odbc_connect("NN.dsn","tj","bismillah",SQL_CUR_USE_ODBC);
$query = "select * from users";
$result = odbc_exec($db,$query);

$num_rows = odbc_num_rows($result);
echo "No of records...".$num_rows."<br>";

while (odbc_fetch_row($result)) {
$realname = odbc_result($result,"realname");
echo $realname."<br>";
}

odbc_close($db);
?>

[Anon]

You should try something like this:
<?
function Count()
{
$inc=0;
while(odbc_fetch_row($result))$inc++
return $inc;
}
?>
I use this and it's working.(you have to catch any errors might appears, such, there is no record in your "$result")