Add filters to .asp page that displays table results.

I have an .asp page that displays a result set based on a table tbl_listings. To see the table go to [ [login to view URL]][1] (login with test/test) It will take you to the page which displays the result set, a copy of the code is attached <[login to view URL]> This page is poplulated by a mysql from a table called table is from tbl_listings. The project is to add some filters to this page. The recordset is the records from tbl_listings that do not have a matching record in tbl_interested. If you look at the sql in the .asp page it does this by counting the number of records in tbl_interested that have the same MLS number(key) to tbl_listings and userid(from cookie) to see if there is a record already in tbl_interested. Currently there are two buttons on the [login to view URL] page 1. Reviewed - adds a record to tbl_review that includes the user id of the user that reviewed the listing and the mls number. Clicking this will then cause the records to disapear from the refreshed [login to view URL] page since there will now be a record in the tbl_interested table with this mls number and userid. 2. Interested - adds a record to tbl_interested that includes the user id of the user that clicked interested and the mls number. Work requested Add Drop Downs 1. Filters by property type (Choices hardcoded - 1F,2F,3F,CN,CP) 2. Filters by city (field ASPX_City) - possible choices in tbl_cities 3. Filter by status (Choices Hardcoded - ACT/DAB/SLD) 4. Filter by reviewed (Reviewed/Not Reviewed based on if there is a record in tbl_review). 5. Filter by Interested (Interested/Not Interested -based on if there is a record in tbl_interested) !!See deliverables section for more info ## Deliverables Add Multiselects/multisubmit 6. Add two check boxes for each listing. One for reviewed and one for interested. Add a button up top that will bulk submit updates to both reviewed and interested tables. Add a button that will check all the boxes for reviwed and all for interested. 7. Add a comments textbox The comments textbox should add a record tbl_comments. When the submit button is checked the comment should be submitted. If any of the checkboxes for reviewed or interested are checked either the inserts to tbl_review and tbl_interested should take place or the status of the check boxes should be preserved. - Winning bidder will be giving FTP access to submit page updates in order to test their work. - I am attaching the .asp and a .sql file that has the mysql table data. - I am expecting additional work for this project to be put on rent a coder later. Winning bid for this phase will be my likely selection for the additonal work. - 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). ## Platform .asp mysql