I have a list of reports built from a table with at least one field called report_id
There is also:
Table users (username & admin_level)
Table team_leads (username)
I display the report by report_id, then generate the list of users based on admin_level to be promoted to team_leads (admin_level=3). I can list them, select the checkbox array and INSERT them into the team_leads table.
Now, if I want to assign more, I could simply go to the original assign_team_leads.php page and select more people to be promoted to team_lead and be tied to the report_id. What I'm having problems with is pulling the list of users with admin_level=3 AND team_leads that are already assigned to that report_id from the team_leads table, then displaying all the users with admin_level=3, and team_leads from the team_leads table with their checkbox already checked.
Too confusing?
