从数据库中只获取第一个元素

Question

I want to show bought "products names" in prestashop orders page. For prestashop 1.6 i already have a code that works, but using the same code on prestashop 1.7 give me duplicate orders ...

public function getProductsName($id_order, $tr)
{
    $products=Db::getInstance()->executeS(
        'SELECT product_name FROM '._DB_PREFIX_.'order_detail
        WHERE id_order='.(int)$id_order);
    $str='';
    foreach($products as $val) {
        $str.=substr($val['product_name'],0,35).'| ';
        }
    $str=trim($str,'|');
    return $str;
}

Answer 1

Ok i found a sulution. Apart from the script i posted above i added to AdminOrdersController.php this piece of sql:

a.id_order AS product_name,

and added to product_name array:

'callback' => 'getProductsName',

and retouched the script to remove the last |:

see updated script in first post.

all changes are in AdminOrdersController.php

Thanks for all.

Final result: http://shrani.si/f/28/pH/2jxmMrf7/qq-photo20190704132806.jpg