Where can i find the product name and description in Prestashop database with Mysql select?
Im creating my own product list and i need make this with mysql_query.
I can find stock,product_id,reference,price,..... but i cant find the product name and product description.
Anybody knows where can i find this values?
At now my select is...
$result = mysql_query("SELECT prod.id_product,prod.reference,prodstock.quantity
FROM ps_product prod, ps_stock_available prodstock
WHERE prod.id_product=prodstock.id_product");
Anybody can help me??