Ok I have a website ([login to view URL]) that allows users (inmates in prison) to buy packages that give them profile slots. The profiles do not have expired date, but the slots do. I need a way to see what accounts have more approved profiles then profile slots. I then need to be able to activate or deactivate the profile (by changing "approved" field to 0 or 1.
I then would need to have some type of report that I can run by date range. The web report would have one inmate per page and would list the profile that has expired. I could add details of the letter to the code. I could print the letters and mail it to the inmates that their profile has expired.
Also I have a page that allows people to email prison inmates. The form adds the info to a table. I need a field IP address added to the form and to be added to the table when submitted. This would be the user IP address and not editable. On the same form I have a "message detail" and need it limited to 500 characters. This could be done by a character limit count down box or after submit pops back with error message that it was too long by blah blah characters. Your choice.
Please review the two word documents for more details. Greater detail about exactly what needs to be changed is in the two word documents.
Thanks,
Michael Bourg