I would like to display the results in a looper (doesn't even have to be nested) I have build the search page (easy), but I can not figure out how to get the result to pul by a "reference_area". Any help will be appreciated.
SELECT tbl_reference.ref_name, Games.GameName, Games.GameShortDesc, Games.GameURL, Games.GameType, Games.GameRef, Games.LibraryUseOnly, Games.GameImage
FROM Games INNER JOIN tbl_reference ON Games.GameRef = tbl_reference.ref_name
ORDER BY GameName
I think the item goes in the KTColParam1 Variable, but I don't know what to put there.