Buy Now
Sign in

Loop event for DB READ

M.Abletech , July 10 at 10:45
M
M.Abletech
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
M.Abletech
Oh, I forgot to say that the result of the second READ DATA should go in a dropdown.