Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

How do I access the results of this query from my template?


Reply


781 Views

Avatar
sarahk

Community Member, 46 Posts

9 May 2008 at 6:34pm

I just put /?showqueries=1 on a page I'm working on and found that I'm querying the database as follows:

SELECT `Group_Members`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `Group_Members` ON `Group_Members`.GroupID = `Group`.ID WHERE (`Group_Members`.MemberID = 1) GROUP BY `Group`.ID

I want to check the results of this query and then display (or not) depending on what has been returned. I'll need to do a check first to see <% if CurrentMember %>.

How do I access those query results?