Exec('SELECT objectid,lang,translation,col FROM languages_texts WHERE type="goods" '); $trans = array(); echo mysql_error(); while(list($object_id, $lang,$translation,$col) = mysql_fetch_row($row_query2)){ //if($lang=='ru') continue; $trans[$object_id][$lang][$col] = $translation; } /* if(isset($_GET['id'])) $id=(int) $_GET['id']; else exit(); */ $row_query = $DB->Exec('SELECT * FROM goods WHERE status="visible" '); echo ''; echo ''; while($row = mysql_fetch_assoc($row_query)) { $goods = new Products(); $images = $goods -> getImages($row['id']); //print_r($images); $s=''; $s .= ' '.$row["id"].''; $s.=''; if(isset($trans[$row['id']])) { foreach($trans[$row['id']] as $lang => $translation) { $s .='<'.$lang.'>'; $s .= ''."\n"; $s .= ''."\n"; $s .=''; } } $s.=''; if(!empty($images)) foreach($images as $image) { $s .= ' '; } $s .=' '.$row["ean"].' '.$row["brand"].' '.$row["price"].' '.$row["price_2"].' '; echo $s; } echo ''; echo '';