two tables from 1 database will be used used: blahblahblah_payments and blahblahbalh_members
The php will need to look something like this [login to view URL]*&month=*&year=*
After user enters in a drop box (1 for month and 1 for year). A new window will open with a simple table (I'm gonna use a graphing package to display the data, so all I need is for the data to come out clean as php variables, so you can just display in a simple chart.) State will not be a choice, I'll create different pages for different states. The php needs to do the following:
Using the month and year selected, it will select these entries from tm_completed in the blahblahblah_payments database. It will then sort by the data and time as well as by the member_id. Then it will check these member_ids against database blahblah_members and display only the state that was for that particular page.
I am sitting here watching this... will take someone who can start right now....