17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 664 Views |
-
How do I access the results of this query from my template?

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?
| 664 Views | ||
|
Page:
1
|
Go to Top |

