I'll try to explain this the best I can... I need 2 pages. All in php and does not need any real html design. The first page will pull a few fields from a database and list them. These are the project names and information. When you select a project, it will pull the project ID. With the project ID, it will search another database for any entries that contain the project id. Should return anywere from 1 to 15 results. From the 1 to 15 results, you will get a 1 to 15 NEW project ids. With the new project ids, you with search a 3rd table for any entries that have any of the new 1 to 15 ids and display the results.
So, on page 1, you will see the main projects, and on page 2, you will see the project details you have selected and all the entries for that project. Once you accept the project, I will give you full access to the database and a list of all the fields.
Project: Test project, ID: tp001
take tp001 and search new table:
Email: firstname.lastname@example.org Project: tp001
Email: email@example.com Project: tp001
and so on
Then it will pull the e-mail addresses that have tp001 and search a new table for emails that have been sent to any email address that matched the project and display the email. The emails are being added to the database already using a perl script on the server.