Need help with subquery in model

[eluser]TheFuzzy0ne[/eluser]
Perhaps it's just me, but I would have thought:

Code:

$prodNumbers = $row2['productNumber'];

should be:

Code:

$prodNumbers[] = $row2['productNumber'];

As you declared this variable as an array. Also, your variable is declared inside of the loop, and therefore is being overwritten with an empty array with each iteration.