Use Prestashop variable into sql query for filtering with WHERE.

[pmaojo]

Hello

 

Im stucked on a problem related with this...

 

Can anyone help me? I want to insert the customer ID into the SQL query with WHERE.

 

How could I use the customer ID variable of Prestashop here to make this work and only show the user his rows?:

 

$eventos = Db::getInstance()->executeS('SELECT * FROM `pss_tabla` WHERE id_cliente=  customer_id  }'); 

Edited April 28, 2014 by pmaojo (see edit history)

[pmaojo]

   global $smarty;

   $userid = $this->context->customer->id;

   $eventos = Db::getInstance()->executeS("SELECT * FROM pss_ev WHERE id_cliente=$userid"); 

   $this->context->smarty->assign('ev', $ev);

 

Edited April 28, 2014 by pmaojo (see edit history)