Posted by Stefan Rybacki on 09/28/05 14: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)

Regards
Stefan

[Back to original message]