Select count value in php

[Santori]

Hello guys, I have a little issue with php:

 

I need to retrieve the count of sql and show it at tpl but results are always 1, not the count results, 

Can you help me please?

 

public function hook()

    {

 

    $sql = (int)Db::getInstance()->Execute ('SELECT COUNT(*) as A  FROM ps_table WHERE validate = 1'); 

    $this->context->smarty->assign(array(

            'variable' => $sql,));

    return $this->display(__FILE__, 'template.tpl');

 

        }

 

Then in template with {$variable} the results = 1, but not the count

 

What Im doing wrong?

Edited December 30, 2016 by Santori (see edit history)

[Santori]

SOLVED:

getInstance()->getValue