help with 'array' / 'while' logic...

[rshelby]

Hey guys! I was hoping you could point me in the right direction.

wrote a php file that gathers all my user names, ids, and their roles.

user ids are connected to a "role" via a connector table.
for example: ID 1 is connected to Role 1, which is "employee"

However, someone may have 2 or more roles (for example you could be an employee, investor, and manager). you get the point.

Here's how I'm pulling the data:

$x=0;

while ($x < $employee_connect_num) {
$user_id[$x]=mysql_result($employee_connect_results,$x,"person_id");
$user_roles[$x]=mysql_result($employee_connect_results,$x,"role_name");
$x++;
}

Then echo back a table with user name and roles.

The problem is, is that it's listing each person, with each of their roles seperately.

example:

Joe Employee
Joe Investor
Joe Manager

I'm trying to get it to list like:

Joe Employee, Investor, Manager

I've tried a few things and I think i'm just complicating things. How would you guys go about this?

thanks!

[weevil]

Where is the code where you are actually printing your data?

[johanafm]

order by name and the approach is identical to http://phpbuilder.com/board/showthread.php?t=10368754

[toxic_brain]

probably by a nested loop, outer to pull out employee name and inner one execute another query on role table and show the roles. If you could sacrifice a bit of performance for a bundle of code lines.

$employee_connect_num = <query for "SELECT person_id FROM <employee table>" >

$x=0;
$y=0;

while ($x < $employee_connect_num) {
$user_id[$x]=mysql_result($employee_connect_results,$x,"person_id");
$his_role_connect_results = <query for "SELECT role_name FROM <role table>" >
$his_role_connect_num = <row count function>;
while ($y < $his_role_count_connect_num) {
$user_roles[$x] .=mysql_result($his_role_connect_results,$x,"role_name");
$y++;
}
$x++;
}