Re: return # of rows

Hello Chuck, On 28-Jun-00 16:21:54, you wrote: >echo odbc_num_rows($result); >^^^^^^ is returning a -1 ???? >Iam running php 4.0 with MS SQL 7 on NT 4 IIS4. There is no way to know how many rows a query returns with high end databases like MS-SQL, Oracle, etc. because these database return rows asyncrounously, ie, they start returning result rows to the client even before the query search has ended on the server. So, when you call the function to get you the number of rows it can't tell you because the query search might not have finished on the server. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --