REPOST: odbc_num_rows question

Does anyone know what might be wrong? Chuck -----Original Message----- I am just getting a -1 when I run the following code. But the result brings back 7 or so records. case "street": $query="select * from risks where lo_numb like '$streetno' and addr_street_name='$streetname'"; //echo $query; break; case "fileno": $file_type=substr($fileno,0,1); $file_no=substr($fileno,1,strlen($fileno)); $query="select * from risks where file_type='$file_type' and file_num='$file_no'"; //echo $query; break; } $result=odbc_do($connection, $query); echo odbc_num_rows($result); ^^^^^^ is returning a -1 ???? Iam running php 4.0 with MS SQL 7 on NT 4 IIS4. Thanks, Chuck -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net