[RevCMS]Selecting groups of the online user

[JeeCee]

Does somebody knows the MySQL query to only select groups where the userid is equal to the id of the user logged in?

In other words: I only want to show the groups which the user has joined. I've tried this, but it doesnt work.

$GetMember = mysql_query("SELECT * FROM group_memberships WHERE userid ='".$_SESSION['id']."'");
while($Member = mysql_fetch_assoc($GetMember))
{
    $GetGroups = mysql_query("SELECT * FROM groups WHERE id='".$Member['groupid']."' ORDER BY id ASC");
    while($Groups = mysql_fetch_assoc($GetGroups))

Any ideas/help?

 

[Crateria]

Where you have the $_SESSION, it should be $_SESSION['user']['id'] not $_SESSION['id'];

 

[JeeCee]

Where you have the $_SESSION, it should be $_SESSION['user']['id'] not $_SESSION['id'];

Thanks, it worked

 

[Crateria]

Thanks, it worked

Glad to help