TexasCHLforum.com

The way you have it setup you don't really need the groups table.

You would just select the user record into a record set and display it in php.

If you change the table structure to a more conventional structure you could do it in a query

A more common way would be to have a table for groups, a table for users and table that joins them together.

user table
[userid][username]

groups table
[groupid][groupname][active]

membership table
[groupid][userid]