What table is used to hold the list of users and the usergroups they belong to?

[Frank H. Shaw]

I modifyed the above script so that the primary usergroup will be displayed from the table in the query above.

This is the modification

PHP Code:


          $myuseruser["$myuser[userid]"] = $myuser['userid'];
          $myuseruser["$myuser[username]"] = $myuser['username'];
          $myuseruser["$myuser[usergroupid]"] = $myuser['usergroupid'];    // No data here and should be

          $myuseruser["$myuser[membergrpoupid]"] = $myuser['membergroupids'];    // No data here and should be 


Looking at the script above the does not seem to contain any date ?

That is this line:

PHP Code:


$myuseruser["$myuser[membergrpoupid]"] = $myuser['membergroupids']; 


To this line:

PHP Code:


 $myuseruser["$myuser[membergrpoupid]"] = explode(',', $myuser['membergroupids']);     // No data here and should be 


What could be the problem you say the stored as a comma-separated list?

I am only getting the first two userid, username, and nothing else but i do get all the user!

Look at the // No data here and should be in both postings

In the user table the fields are defined as follows

PHP Code:


    usergroupid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    membergroupids CHAR(250) NOT NULL DEFAULT '', 


THANKS

Frank H. Shaw

PS sorry about not including the PHP tags but it was not the whole script!