RE: Row Count

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

 



jay...

he's dealing with informix.. not sure if mysql/php calls apply.


-----Original Message-----
From: Jay Blanchard [mailto:jblanchard@xxxxxxxxxx]
Sent: Tuesday, June 10, 2008 7:19 AM
To: Dan Shirah; php-general
Subject: RE:  Row Count


[snip]
I am having a problem with trying to count the number of rows returned
by my
query. I connect to the database fine, my query displays and runs fine,
but
my row count is incorrect.

If I do not put in any serch criteria and my basic query ends up being
"SELECT * FROM brev_pending_summary_detail" then the value of $rowcount
is
110796. If one search criteria is used the value of $rowcount becomes
11080.
If both criteria are used the value of $rowcount is 1108.  110796 is the
correct value of my total rows in the table, but the other two values
are
inncorrect and appear to just be one digit shorter and rounded off.
[/snip]

http://www.php.net/mysql_num_rows


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

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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux