Hello all. Quick question.
I have a table in my database with 'feedback' items which are assigned to pages/items in another database. I have a inner join to list all of the items on the feedback table and which items they are listed on.
I have used a DISTINCT on the ref# field of the feedback query to stop it showing duplicate feedback entries on the page, then I have a foreach on the items returned. In the foreach I run a query for the ref# of the feedback item to generate a list of all pages/items that it is listed on.
Can't find anything of use on the interweb, but I know there has to be something somewhere, i'm probably searching for the wrong thing.
Can anyone suggest a more efficient way of doing this?