17488 Posts in 4473 Topics by 1978 members
|Go to End|
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?
|Go to Top|