63641 MySQL output in PHP

I am running a PHPnuke website … I have a members only area where people already input reports on progress daily. I need a program to display the results for one person. I'd like to select the client's name from a drop-down list – obviously identified by their linked UID. Then the following would be printed to a restricted access web page :- (I can supply the code to restrict the access). If date of last daily report is more than 48 hours ago, then print randomised from a text document named ./Randomisers/[login to view URL] If daily report has been filed within the last 24 hours, then compare the person's daily data to the same person's previous day's report. There are 22 fields within the daily reports, but only ten which need comparisons. These ten are on a scale of 0-10 … some positive (i.e. their optimum level is 10) and some negative (i.e. their optimum level is zero). If SE is higher than yesterday, then select a random comment from [login to view URL] If SE is lower than yesterday, then select a random comment from [login to view URL] If SE is 1, then select a random comment from [login to view URL] If SE is 2, then select a random comment from [login to view URL] And so on, up to the number 10, and with 8 more fields. Obviously if you can write the code once, I can copy and paste and rename, although you may be happier to do this yourself to ensure that it flows neatly. I then intend to copy and paste the text from the webpage into my email package, amend as necessary and send manually. Presumably no programming can be viewed by the copying and pasting of text from the HTML / PHP page to an email but if it can, please let me know so I can rethink the process. - I would like a linked web-page to show weekly averages for each of 9 fields. - If graphs are possible, this would be helpful but not vital. - I'd like the system to advise which field most closely follows the HP field. Not sure if this is possible, though because some of the scales are positive and should be the higher end of the scale of 0-10, while others are negative and should be at the lower end of the scale of 0-10. Please be clear when quoting whether you are able to include graphs and if you are also able to display which field most clearly follows the HP field.