PHP Query with HTML Display

I want to run a php query and html display that is fairly complicated, but some of the code for this is already written within a file I have created called data.php. Really, this file should be a modification of [login to view URL] more than anything else. Currently, [login to view URL] calls up all the rows in the table "data" for a given idnumber that is input by the user, and displays it in an html table. The html table takes the data and displays it in chronological order in columns. I will attach the [login to view URL] page, along with pieces from the necessary mysql tables so you can see how it operates. Below, I will also describe the project in further detail. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). What I would like delivered is the following: a file that retrieves and displays data in much the same manner as data.php. While [login to view URL] uses a session variable called idnumber to then pull all the appropriate rows from the table 'data', that same session variable will pull rows now from the tables 'otherdata' and 'otherdata_types'. First off, you're looking for all the rows in the table where the value in column "company_id" matches a session variable set by the user called $company_id. Then each of the eight columns will be displayed as follows; 1. 'id' This is just an autoincrement column and won't be used at all here yet. 2. 'company_id' This is the column that contains the company_id numbers and will be used to find the appropriate rows, but the values won't be displayed on the page anywhere. 3 and 4. 'year' 'quarter' These two will form the columns on the html page, creating a chronological order for the data in descending order. 5. 'data' This is the piece of data that will be shown for the appropriate year and quarter. 6. 'otherdata_type' This is the most complicated piece. It is a number for which there is a corresponding value in the table "otherdata_types". The text in that corresponding row will be displayed in the html in the first column on the html page so as to label each row of data. Furthermore, in the "otherdata_types" table there is a column called parent_id, which basically names the parent entry for each entry in the table. I'll set up an example- Here are four sample rows from the table "otherdata_types" id | name | parent_id | units 2 Energy Reserves 8 MBOE 8 Property & Equipment 21 Proved Reserves 2 MBOE Now in this example let's say that the value in column 'otherdata_type' in the table "otherdata" is 21. The code should then find the row where 'id' is 21 in the table above, and it should display Proved Reserves in the html row. It should also find the parent_id value (2), and find the corresponding value for that row (Energy Reserves). If the units values match, then nothing should be displayed after "Proved Reserves". If they did not match, then the html should display "Proved Reserves (MBOE)". Now, the code should trace each parent value back until it finds a value for which there is no parent_id, in this case 'Property & Equipment', and then display them as follows on the html page: Property & Equipment [inserted slightly]Property & Equipment (MBOE) [inserted more]Proved Reserves The most parent entry, in this case Property & Equipment will always be a header for the table, and not actually fall within the table of data. Hopefully that all makes some sense to you. 7. 'geography' This column indicates which geographical location the data is referencing. In most cases it will be a value of one, indicating it is global and nothing should be added. However, if it is a different number, then that number should be looked up in the table "geography" and the value in column 'location' should be displayed next to the text for the row on the html page. Using the above example, if the row of data had an 'otherdata_type' of 21 and a 'geography' of 3, then it would look for the value 3 in the column 'id' in the table "geography" and find "North America" for a value, and display as follows Property & Equipment [inserted slightly]Property & Equipment (MBOE) [inserted more]Proved Reserves [inserted even more]Proved Reserves (North America) 8 and 9. 'uid' and 'date' These have no relevance yet. So that's everything. I will send excel versions of the three tables above so you can get a better feel for them. In terms of display it should look like the html in data.php. ## Platform All versions of IE and Netscape