[ciapug] Adodb: RecordCount()

[Chris Hettinger]

Replied to quickly...=20

 $sql =3D "SELECT * FROM states";
 $results =3D $db->Execute($sql);
 // returns 50 records

 $count =3D $results->RecordCount();
 echo $count;

This is showing 0. *hrmm*

-----Original Message-----
From: Chris Hettinger=20
Sent: Friday, October 24, 2003 9:38 AM
To: ciapug@cialug.org
Subject: RE: [ciapug] Adodb: RecordCount()


that did smee to work without returning and "undefined funtion" =
thanks!!! now to get the count to be accurate.

-----Original Message-----
From: Lathrop Preston [mailto:laith@prestonfam.org]
Sent: Friday, October 24, 2003 9:30 AM
To: ciapug@cialug.org
Subject: Re: [ciapug] Adodb: RecordCount()



This is ugly but it should work in most db

"SELECT *, count(*) as foo_cn FROM states";

As far as RecordCount goes... it is a function for the record set Not=20
the connection...

use

$count =3D $results->RecordCount();

Laith

Chris Hettinger wrote:

> I am having a small issue with the Adodb (version 4.01) function =
RecordCount().
> Here is the documentation on this function: =
http://phplens.com/lens/adodb/docs-adodb.htm#recordcount
>=20
> Example:
> $sql =3D "SELECT * FROM states";
> $results =3D $db->Execute($sql);
>=20
> // result set should then list 50 records
>=20
> I am having an issue with the syntax to use this function.... I would =
assume I would need pass it my result set or the query??? I have tried =
several different ways...
>=20
> $count =3D RecordCount($sql);
>=20
> or
>=20
> $count =3D $db->RecordCount($sql);
>=20
> ... No matter what I try I receive the error: Fatal error: Call to =
undefined function: recordcount()...
>=20
> I want to know the number of records returned in my result set. I =
don't want to use a counter and while loop to do this.
>=20
> -Chris Hettinger, Web Specialist
> -IFMC/ENCOMPASS
> -www.encompas.com
> -(515) 279-8730
>=20
>=20
>=20
> CONFIDENTIALITY NOTICE:  This communication, including any attachment, =
may contain confidential information and is intended only for the =
individual or entity to whom it is addressed.  Any review, =
dissemination, or copying of this communication by anyone other than the =
intended recipient is strictly prohibited.  If you are not the intended =
recipient, please contact the sender by reply email, delete and destroy =
all copies of the original message.'
>=20
> _______________________________________________
> ciapug mailing list
> ciapug@cialug.org
> http://cialug.org/mailman/listinfo/ciapug


_______________________________________________
ciapug mailing list
ciapug@cialug.org
http://cialug.org/mailman/listinfo/ciapug


CONFIDENTIALITY NOTICE:  This communication, including any attachment, =
may contain confidential information and is intended only for the =
individual or entity to whom it is addressed.  Any review, =
dissemination, or copying of this communication by anyone other than the =
intended recipient is strictly prohibited.  If you are not the intended =
recipient, please contact the sender by reply email, delete and destroy =
all copies of the original message.'

_______________________________________________
ciapug mailing list
ciapug@cialug.org
http://cialug.org/mailman/listinfo/ciapug


CONFIDENTIALITY NOTICE:  This communication, including any attachment, =
may contain confidential information and is intended only for the =
individual or entity to whom it is addressed.  Any review, =
dissemination, or copying of this communication by anyone other than the =
intended recipient is strictly prohibited.  If you are not the intended =
recipient, please contact the sender by reply email, delete and destroy =
all copies of the original message.'