echo '
<table id="price" width="550px" border"1"
    <tr>
    <th>Название</th>
    <th>Описание</th>
    <th>Артикул</th>
    <th>Цена</th>
        ';
            $query = "SELECT id_product
                        FROM ps_product_lang
                        WHERE id_lang =3
                        ORDER BY `id_product` ASC";
   $sql=mysql_query($query) or die("Query failed : " . mysql_error());
   while($arr = mysql_fetch_assoc($sql)){
            foreach($arr as $value){
                $query = "SELECT name, description_short
                        FROM $product_lang
                        WHERE id_product = $value AND id_lang = 3";
                $query1 = mysql_query($query) or die("Query failed : " . mysql_error());
                $arr1 = mysql_fetch_array($query1);
                $query = "SELECT price, reference
                            FROM ps_product
                            WHERE id_product = $value";
                $query2 = mysql_query($query) or die("Query failed : " . mysql_error());
                    
                    $arr2 = mysql_fetch_array($query2);
                    echo '<tr><td>'.$arr1["name"].'</td><td>'.$arr1["description_short"].'</td><td>'.$arr2["reference"].'</td><td>'.substr($arr2["price"],0,5).'</td></tr>';
                    }
            }

<?php
include(dirname(__FILE__).'/config/config.inc.php');
include(dirname(__FILE__).'/init.php');

foreach($arr as $value){
                $query = "SELECT name, description_short
                        FROM $product_lang
                        WHERE id_product = $value AND id_lang = 3";