[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
jay...
he's dealing with informix.. not sure if mysql/php calls apply.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2008 7:19 AM
To: Dan Shirah; php-general
Subject: RE: [PHP] Row Count
[snip]
I am having a problem with trying to count
On Tue, Jun 10, 2008 at 10:11 AM, Dan Shirah [EMAIL PROTECTED] wrote:
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
On Tue, Jun 10, 2008 at 10:18 AM, Jay Blanchard [EMAIL PROTECTED] wrote:
http://www.php.net/mysql_num_rows
That would be just peachy if it worked on his Informix database, Jay. ;-P
--
/Daniel P. Brown
Dedicated Servers - Intel 2.4GHz w/2TB bandwidth/mo. starting at just
$59.99/mo. with
Jay,
I am querying an Informix database, not MySQL.
When I count the rows against my MSSQL database I do use the mssql_num_rows
function and it works great. I tried using the ifx_num_rows function with
the ifx_fetch_row function but could not seem to get it to work, so instead
I used the
[snip]
On Tue, Jun 10, 2008 at 10:18 AM, Jay Blanchard [EMAIL PROTECTED]
wrote:
http://www.php.net/mysql_num_rows
That would be just peachy if it worked on his Informix database,
Jay. ;-P
[/snip]
OK, OK...so I read it through too quickly!
Then I would suggest a second query to count the
On Tue, Jun 10, 2008 at 10:39 AM, Jay Blanchard [EMAIL PROTECTED] wrote:
ifx_num_rows may be soon to be an included function.
Does anyone else smell PECL's? ;-P
--
/Daniel P. Brown
Dedicated Servers - Intel 2.4GHz w/2TB bandwidth/mo. starting at just
$59.99/mo. with no contract!
Daniel Brown wrote:
On Tue, Jun 10, 2008 at 10:11 AM, Dan Shirah [EMAIL PROTECTED] wrote:
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
On Tue, Jun 10, 2008 at 10:54 AM, Jim Lucas [EMAIL PROTECTED] wrote:
Daniel Brown, did you read through this too quickly also???
Jim Lucas, what did I miss?
--
/Daniel P. Brown
Dedicated Servers - Intel 2.4GHz w/2TB bandwidth/mo. starting at just
$59.99/mo. with no contract!
Dedicated
Dan Shirah wrote:
Hello all,
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
Daniel Brown wrote:
On Tue, Jun 10, 2008 at 10:54 AM, Jim Lucas [EMAIL PROTECTED] wrote:
Daniel Brown, did you read through this too quickly also???
Jim Lucas, what did I miss?
He is using the ifx extension for an informix database, not mysql
--
Jim Lucas
Some men are born to
On Tue, Jun 10, 2008 at 11:08 AM, Jim Lucas [EMAIL PROTECTED] wrote:
Daniel Brown wrote:
On Tue, Jun 10, 2008 at 10:54 AM, Jim Lucas [EMAIL PROTECTED] wrote:
Daniel Brown, did you read through this too quickly also???
Jim Lucas, what did I miss?
He is using the ifx extension for an
[snip]
He is using the ifx extension for an informix database, not mysql
[/snip]
Dan was one of the ones who so clearly corrected me! Wow, are we all
rushing through stuff today??
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tue, Jun 10, 2008 at 11:27 AM, Jay Blanchard [EMAIL PROTECTED] wrote:
[snip]
He is using the ifx extension for an informix database, not mysql
[/snip]
Dan was one of the ones who so clearly corrected me! Wow, are we all
rushing through stuff today??
I know. I should be ashamed.
jay...
nah... jus that we saw the msg at the same time!!! a freak occurance.
-Original Message-
From: Daniel Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2008 8:30 AM
To: Jay Blanchard
Cc: Jim Lucas; Dan Shirah; php-general
Subject: Re: [PHP] Row Count
On Tue, Jun 10, 2008
Jim Lucas wrote:
Dan Shirah wrote:
Hello all,
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
On Tue, Jun 10, 2008 at 12:42 PM, Jim Lucas [EMAIL PROTECTED] wrote:
Jim Lucas wrote:
I should slow down also and make sure all is well with my messages before
sending.
$query = 'SELECT COUNT(*) FROM brev_pending_summary_detail '; // BASIC QUERY
Yeah that and quit stealing the code
Quit top-posting, Shirah. You know better than that. ;-P
On Tue, Jun 10, 2008 at 1:49 PM, Dan Shirah [EMAIL PROTECTED] wrote:
print_r($rowcount); returns Array ( [(count(*))] = 110796.0 ) and 110796 is
the correct number of rows in my table, but that number isn't coming through
the the
Sorry about the top posting. slaps hand
You my friend are a genious! $rows = $rowcount['(count(*))'] works like a
charm!
Thank you all.
Okay, I decided to try the COUNT method since all I really wanted to get in
the first place was how many rows would be returned for a specific query.
So, I have the below:
?php
if (!$connect_id = ifx_connect([EMAIL PROTECTED], $user, $pass)) { // THE
ACTUAL CONNECTION
echo Unable to
On Tue, Jun 10, 2008 at 1:43 PM, Dan Shirah [EMAIL PROTECTED] wrote:
I'm not getting any errors, but no number/data displays for $rows when it
should be telling me there is over 100,000 records.
Any ideas why it isn't returning a number value for $rowcount[0]/$rows?
Try to
print_r($rowcount); returns Array ( [(count(*))] = 110796.0 ) and 110796 is
the correct number of rows in my table, but that number isn't coming through
the the variable.
On 6/10/08, Daniel Brown [EMAIL PROTECTED] wrote:
On Tue, Jun 10, 2008 at 1:43 PM, Dan Shirah [EMAIL PROTECTED] wrote:
[snip]
print_r($rowcount); returns Array ( [(count(*))] = 110796.0 ) and
110796 is
the correct number of rows in my table, but that number isn't coming
through
the the variable.
[/snip]
Because ifx_fetch_row returns an array, not a value.
--
PHP General Mailing List (http://www.php.net/)
To
Dan Shirah wrote:
Sorry about the top posting. slaps hand
You my friend are a genious! $rows = $rowcount['(count(*))'] works like a
charm!
Thank you all.
So in your query, add this
SELECT COUNT(*) as total FROM your_table
Then in your code use this instead
$rows = $rowcount['total'];
On Tue, Jun 10, 2008 at 3:51 PM, Jim Lucas [EMAIL PROTECTED] wrote:
So in your query, add this
SELECT COUNT(*) as total FROM your_table
Then in your code use this instead
$rows = $rowcount['total'];
This makes a little more sense then using the count(*) thing, to me at least
Good
25 matches
Mail list logo