Use a foreach statement to build an array

[jthayne]

So what do you think it is that solved it?

[deliriousthunder]

I think I explained it in the PM, it's difficult to explain without going into a detailed explanation of what the query is for.

If you didn't read the whole message I wouldn't blame you, but if you skim it and read the last paragraph or 2 you'll get it.

My query needed an extra field, (that I hadn't thought of), checked in one of the WHERE/OR clauses to ensure that no duplicates appeared in the array.

It's done now and seems to be working. I'm just about to start testing it more thoroughly.

[jthayne]

Glad it is working now. I wasn't sure which was the answer when I read through it and which was the original message.

Let me know if there is anything else I can help with -- even if it is to just bounce some ideas off.