Re: Executing SQL query with ODBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

Most databases don't return the number of rows in the results of a select 
statement to odbc_num_rows. See:

http://www.php.net/manual/en/function.odbc-num-rows.php

Usually the way to determine the number of rows a select returns is to 
either fetch them all and count them or do an additional aggregate query. 
It depends on your requirements.
I presume that this behaviour is because in most cases the database engine 
does not make the number of rows in a result set available to the driver. 
The only way the php interface could calculate the number of rows would be 
to fetch them all which may be inefficient - say if you were only 
interested in the first row out of a possible 100. [anybody else care to 
comment?]

Note, after an insert, update and delete statements odbc_num_rows does 
return the number of rows affected.

cheers Simon

On Tuesday 09 November 2004 08:09, Petrus Ali Saputra wrote:
> Here is my code:
> $conn = odbc_connect("Ta Fara","","");
> $query = "SELECT * FROM Config";
> $result = odbc_exec($conn, $query);
> echo odbc_num_rows($result);
>
> This code never give me a 0 result even there is some data. How can I
> solve it? Thank you.
> --
> Petrus Ali Saputra
> ==========================================================
> Addr. : Karang Empat Besar 76
>          Surabaya 60133
>          East Java, Indonesia
> Phone : 62-31-381-7866
>          62-31-6010-2653
>          62-81-23000-254
> ----------------------------------------------------------
> A professional web hosting for your business and corporate
> URL   : http://attractive.as/hostmania
> ----------------------------------------------------------
> Mau kredit mobil baru/bekas dengan bunga rendah?
> URL   : http://fantastic.as/kreditmobil

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Simon Rees  |  srees@xxxxxxxxxxxxx  |
ORA-03113: end-of-file on communication channel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux