Posted by Matthew Weier O'Phinney on 04/11/05 21:21

* Reynier Perez Mira <rperezm@estudiantes.uci.cu>:
> I'm using PEAR DB and Smarty. The case is that I have to pass a value =
> from a query result to a Smarty var. I try to paginate results. See the =
> code below:
>
> /////////////////////////////////////////////////////////////////////////=
>
> SmartyPaginate::connect();
> SmartyPaginate::setLimit(5);
> $gbresult =3D $database->query("SELECT * FROM libro_de_visitas LIMIT " . =
> SmartyPaginate::getCurrentIndex() . "," . SmartyPaginate::getLimit());
> $gbtotal =3D $database->query("SELECT COUNT(*) AS total FROM =
> libro_de_visitas");
> $gbtotal->fetchRow();
> SmartyPaginate::setTotal($gbtotal['total']);
>
> /////////////////////////////////////////////////////////////////////////=
>
> As you can see I need the COUNT value but I not know how get it from =
> query using PEAR. Some body can help me?

You'll need to do two different queries, one that counts the number of
total results for the criteria, and one that pulls the set with a LIMIT
statement.

--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:matthew@garden.org | http://vermontbotanical.org

[Back to original message]