Help with arrays

[cri-miller]

Trying to create a report using php with mysql that groups sales persons in an array within their own array of sales leads. An example.

I have sales people inputting leads into a database from sales to new marketing ideas. I can produce each salesperson individually in a report but the sales manager would like all sales team on one report.

I would like the report to look like this:

John Smith
Week 10 Report

{Create table} Title Sales Leads
Sales Lead 1
Sales Lead 2
Sales Lead 3

{Create table} Title Marketing ideas
Marketing Idea 1
Marketing Idea 2
Marketing Idea 3

Linda Thompson
Week 10 Report

{Create table} Title Sales Leads
Sales Lead 1
Sales Lead 2
Sales Lead 3

{Create table} Title Marketing ideas
Marketing Idea 1
Marketing Idea 2
Marketing Idea 3

etc....

Any suggestions?

[stevesweetland]

desribe your database structure a little more

[cri-miller]

Two tables: one for sales leads and one for marketing. The project manager in each table is what I group by. Each table contains the id, project manager, week of the year, and the recap.