[grant.hayman]

Thanks Farcaster,

I replaced the RIGHT JOIN with INNER JOIN and it does indeed produce the same result which confused me because i thought that would bring back results from both tables which where identical i didnt relised it ignored the blank results (still learning, cheers).

the results of the query will be held as an array and outputted to a module for display.

I would love to add a position to the array and the only way i could see to do this was to add a positions filed on the fly so position is held in the array do you know of any way of doing this... I'm guessing this is not possible but was wondering if you knew a way of doing this without a complicated subselect or temp table which im sure would slow everything down.

Any thoughts would be appreciated.

Grant

--------------- Added [DATE]1200331410[/DATE] at [TIME]1200331410[/TIME] ---------------

Sorted the position thing... I was limiting myself to try to use a script i had ... (not the best way to do it lol) I just rewrote the script.