Loop event for DB READ

M.Abletech 10 Jul, 2018
Hi,

from a first DB READ I got an array of results. I need to make a second DB READ on a different table for each row of the array.

this is the array:

Array
(
    [read_data8] => Array
        (
            [log] => Array
                (
                    [0] => SELECT COUNT(*) AS `Article2.count` FROM `kizgv_fields_values` AS `Article2` WHERE `Article2`.`value` = 'BIOS MANAGEMENT SRL' AND `Article2`.`field_id` = '8';
                    [1] => SELECT `Article2`.`item_id` AS `Article2.item_id` FROM `kizgv_fields_values` AS `Article2` WHERE `Article2`.`value` = 'BIOS MANAGEMENT SRL' AND `Article2`.`field_id` = '8' LIMIT 30;
                )

            [var] => Array
                (
                    [2664] => 2664
                    [2666] => 2666
                    [2870] => 2870
                    [3127] => 3127
                    [4947] => 4947
                    [5406] => 5406
                    [5691] => 5691
                    [5809] => 5809
                )

        )

)

So I insert a loop event ( please see in screenshot http://prntscr.com/k4otyl )

Am I targeting it wrong?

Because nothing shows in debugger.

If I make all without loop and limit the result from first READ DATA to first matching it works. So I get there is a problem with the iteration method.

If anyone can help, thanks a lot!
M.Abletech 10 Jul, 2018
Oh, I forgot to say that the result of the second READ DATA should go in a dropdown.
This topic is locked and no more replies can be posted.