Re: how to move into a recordset?

Stefan Rybacki said the following on 28/09/2005 12:43: 
Oli Filth wrote:

s4femod3 said the following on 28/09/2005 04:05:

y not try odbc_num_rows($query); ?

this function will return the number of rows in an ODBC result. This
function will return -1 on error. For INSERT, UPDATE and DELETE
statements odbc_num_rows() returns the number of rows affected. For a
SELECT clause this can be the number of rows available.


Alternatively, why not include a COUNT(*) in your SELECT query?

I don't think that this is working, since as soon as you have a count(*) in your SELECT clause, the query returns just one row (if you didn't use group by, but in this case the count function won't help anyway)


Oh yes, you're absolutely right! Silly me. ;) I guess you could execute a SELECT COUNT(*)... query to get the row count before the actual SELECT query itself.

--
Oli
.