Problem to add table

[Yuto]

Hi all !

 

I have create a new table called "ps_product_avis" in my database to add a field of notation in my product.

 

In ProductController.php :

 public function initContent()
    {
        global $smarty;
$avis=Db::getInstance()->ExecuteS("select commentaire from "._DB_PREFIX_."product_avis");;
$smarty->assign('avis',$avis);

In product.tpl :

 <li>avis : {$avis}</li>

This method dosn't work. 

Someone could tell me how add the fields of my new table in my website please ?

 

I want create a list of opinions for each of my products.

 

Thanks a lot in advance.

[Yuto]

Up :/