Newsletter subscription / member database

I am selling subscriptions to a newsletter which is being paid through paypal. Following this sign up, I want to have the subscriber become a member of our organization. I need a database to track member information. SUMMARY of the PROCESS: 1. Pay for Newsletter ??" using PAYPAL account. This part is already done. Eveything else has to be created. <!-- --> 1. Register for membership ??" Enter sponsor id. If they don’t know sponser’s id number, they can enter a name. Administrator can manually look it up. <!-- --> 1. Get userid/password for access to member-only area of the website. ## 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). * * *PROCESS: 1. Pay for Newsletter ??" using PAYPAL account. This part is already done. 2. Register for membership ??" Enter sponsor id. If they don’t know sponser’s id number, they can enter a name. Administrator can manually look it up. 3. Get userid/password for access to member-only area of the website. Subscribe / pay for newsletter. Using paypal. Join as member ??" with sponsor id. Fill in form with some data..(address, phone, emails, etc.) Password created and emailed to new member. Memberid/password combination necessary to access members area of the web site. FIELDS NEEDED: Status: MEMBER, ACTIVE MEMBER, COMMUNITY LEADER, PROJECT MANAGER, DISTRICT MANAGER, REGIONAL MANAGER, BOARD MEMBER DATE JOINED= automatically generated MEMBER ID - unique integer sequential SPONSOR’s MEMBER ID - Enter number if known or put i n 0 and in another field put in sponsor’s name if sponsor’s userid is unknown. NAME, ADDRESS, TELEPHONE NUMBERS, EMAIL, 2NDEMAIL Welcomeaboard.html. ??" landing page after completing registration DATABASE REQUIREMENTS 1. LIVE 2. Must be automatically sign people up. 3. User must be able to log in and modify personal information, but not have access to other people’s information. 4. Must have admin interface for administrator to modify information. After Subscribing... Join as member ??" with sponsor id. Fill in form with some data..(address, phone, emails, etc.) Password created and emailed to new member. Memberid/password combination necessary to access members area of the web site. FIELDS NEEDED: Status which can be: MEMBER, ACTIVE MEMBER, COMMUNITY LEADER, PROJECT MANAGER, DISTRICT MANAGER, REGIONAL MANAGER, BOARD MEMBER DATE JOINED= automatically generated LASTUPDATE = automatically generated whenever record i s updated or added. MEMBER ID - unique integer sequential SPONSOR's MEMBER ID NAME, ADDRESS, ADDRESS2, CITY, STATE, ZIP, TELEPHONE1, TELEPHONE2, TELEPHONE3, EMAIL, EMAIL2 ---------------------- After database registration: Welcomeaboard.html. ??" landing page after completing registration --------------------------- ADDITIONAL DATA REQUIREMENTS 1. LIVE 2. Must be able to automatically sign people up. 3. User must be able to log in and modify personal information, but not have access to other people’s information. 4. User must be able to get a report of the number of people who he has sponsored directly and indirectly. 5. Must have member-only access area on website that is password protected for entry. Please let me know if you have any questions. Thank you for your interest. Regards, Drew * * * ** Note MYSQL was installed today and is now an option. * * *This broadcast message was sent to all bidders on Tuesday Nov 14, 2006 1:43:00 PM: Thanks for your interest... Please revise your bids as I would like to select a coder as soon as possible. MySQL has been installed and is a viable option for this project. Your choice. Regards, Drew ## Platform Red Hat Linux 9.9 PostgreSQL or MySQL 5.0.27 PHP