на выводит данные
 

добрый день!

есть 2 запроса: первый находит номера в определенной таблице, а второй из полученных данных ищет в остальных таблицах. сделал так

$result1 = mysql_query("
        SELECT ART.ART_ID, ART.ART_ARTICLE_NR
        FROM ARTICLES AS ART
        WHERE ART.ART_ARTICLE_NR like '%".$f_1."%' AND ART.ART_ID like '%".$f_2."%'
    ");
    $i = 0;
    if (mysql_num_rows($result1) > 0) {
        while($a = mysql_fetch_row($result1))
        {
            $i++;
            $res = mysql_query("
                SELECT
                    shop_items_catalog_item_id as item_id,
                    shop_items_catalog_marking,
                    shop_items_catalog_name,
                    shop_vendorcode,
                    round((
                        (SELECT shop_warehouse_items_count FROM shop_warehouse_items_table WHERE shop_warehouse_id = 3 AND shop_items_catalog_item_id = item_id) +
                        (SELECT shop_warehouse_items_count FROM shop_warehouse_items_table WHERE shop_warehouse_id = 4 AND shop_items_catalog_item_id = item_id) +
                        (SELECT shop_warehouse_items_count FROM shop_warehouse_items_table WHERE shop_warehouse_id = 5 AND shop_items_catalog_item_id = item_id)
                    ),0),
                    round((SELECT shop_warehouse_items_count FROM shop_warehouse_items_table WHERE shop_warehouse_id = 4 AND shop_items_catalog_item_id = item_id),0),
                    round((SELECT shop_warehouse_items_count FROM shop_warehouse_items_table WHERE shop_warehouse_id = 3 AND shop_items_catalog_item_id = item_id),0),
                    round((SELECT shop_warehouse_items_count FROM shop_warehouse_items_table WHERE shop_warehouse_id = 5 AND shop_items_catalog_item_id = item_id),0),
                    (SELECT shop_prices_to_item_value FROM shop_prices_to_item_table WHERE shop_list_of_prices_id = 4 AND shop_items_catalog_item_id = item_id),
                    (SELECT shop_prices_to_item_value FROM shop_prices_to_item_table WHERE shop_list_of_prices_id = 5 AND shop_items_catalog_item_id = item_id)
                FROM `shop_items_catalog_table`
                WHERE
                    shop_vendorcode = '{$a[1]}' AND shop_items_catalog_marking = '{$a[0]}'
                ORDER BY 
                    shop_vendorcode
            ");
            if (mysql_num_rows($res) > 0) {
                while ($b = mysql_fetch_row($res)) {
                    if ($b[4] > 0) {
                        echo "<tr align='center' id='tr2_{$i}'>
                            <td id='tr_{$i}_1'>{$a[1]}</td>
                            <td id='tr_{$i}_2'>{$a[2]}</td>
                            <td id='tr_{$i}_3' align='left'>{$a[2]}</td>
                            <td id='tr_{$i}_4'><div id='hide_{$i}' style='display: none;'>{$a[8]}</div></td>
                            <td id='tr_{$i}_5'>{$a[9]}</td>
                            <td id='tr_{$i}_6'>{$a[4]}</td>
                            <td id='tr_{$i}_7'>{$a[5]}</td>
                            <td id='tr_{$i}_8'>{$a[6]}</td>
                            <td id='tr_{$i}_9'>{$a[7]}</td>
                    }
                }
            }
        }
    }

но он не выводит данные:( :( не подскажите почему?

Ужас какой, аж 8 подзапросов.

Учитесь отлаживать свой код, больше тут нечего советовать.