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

[Frank H. Shaw]

I will from this point forward use the PHP start and ending tags on all PHP sniplets of PHP.

The following script below produces the following out put which is not really what i want

1
fshaw
6
9,10,11,12,13

This is for the first record and is correct now - but I want to take the comma-separated list of numbers and it is only for the membergroupids' which produced the last line above 9,10,11,12,13 and parse that comma-separated list so that if i was going to print ir out with a echo it would be unstead like this

9
10
11
12
13

The other values are stored just fine.

Once i have that figured out I need to store the elements in a array so that I can manage the data later on easly.


Here is my script below that craeted the output above.

PHP Code:


 global $myuser;

 $myuser = array();

 $myusers = $vbulletin->db->query_read("SELECT userid, username, usergroupid, membergroupids FROM " . TABLE_PREFIX . "user ORDER BY userid");
 
 while ($myuser = $vbulletin->db->fetch_array($myusers))
      {

          echo($myuser['userid'] . "<br />");
          echo($myuser['username'] . "<br />");
          echo($myuser['usergroupid'] . "<br />");
          echo($myuser['membergroupids'] . "<br />");

      } 


THANKS

Frank H. Shaw