Hello List:
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 = $database->query("SELECT * FROM libro_de_visitas LIMIT " .
SmartyPaginate::getCurrentIndex() . "," . SmartyPaginate::getLimit());
$gbtotal = $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?
Regards
Reynier P�rez Mira
3ero. Ing. Inform�tica
Entre m�s inteligente me siento, m�s me doy cuenta de lo ignorante que soy.
