The parameter passed to the odbc_fetch_row function is a result identifier, meaning an integer which is used to identify the results of a previous query. What you need to do is execute your query, save the result returned, and then use that result, like this:
<?
// open a connection first, otherwise odbc_query will fail
$query = "
SELECT *
FROM my_row
";
$result = odbc_query($query);
$count = 0;
while (odbc_fetch_row($result)) {
$count ++;
}
print "$count rows found.";
?>
You may also be able to use odbc_num_rows to find the number of rows returned, but I've heard of problems with that odbc function (the mysql_num_rows function works fine though).
-Keegan
