[Replicant]

Originally Posted by VineetN

I was just trying to get the membergroup ids from the db of a logged in user.

Are you looking for primary and secondary usergroups or just the primary?

Originally Posted by VineetN

It would be a great help if I get a example code snippet to fire a sql query within the template hook.
Thanks for the reply..:-)

You can't just fire an sql query within a template hook. You can call vB api or your own custom api using the vb:data call in the template.

Here is an example of how to use it. This is used to get profile data for a user

{vb:data postInfo, user, fetchProfileInfo, 6}

postInfo is the variable the data is returned to. user is the api. fetchProfileInfo is the method being called. 6 is the userid. once this is called, you can display the data by using vb:raw.

{vb:raw postInfo.usergroupid} would display the usergroup id of userid 6