Php Mailer
I am starting a Lead CO-OP for my team.
My plan is to have a php form with 1 mysql database with 2 tables.
First table (called members) has email addresses of members, and how many shares they have. The next table has leads (and is called leads)…these will have different fields unfortunately (sometimes I will know birthdays, time to call etc…sometimes not), but each lead will occupy one row in the table.
here’s the basic idea:
1. someone fills out the form with their email address
2. basic script to check the members database and see how many shares in the CO-OP he/she has 0 or null means no email is sent.
3. If they have a share or more, send an email to the email address provided with 100 leads (or any number I ultimately pick) from the leads database for each share the member holds.
3. once those 100 (or 200…500 or however many shares they have) leads are sent to the member they are deleted from the leads database – so when the next person fills out the form they get different leads.
4. make some sort of timer, or some way to only send leads out once every 24 hours. (this is a part I am not sure how to do)
5. I will be loading up all the leads manually, so I would like to receive a reminder email when the database has less than 1000 (or whatever number I pick) leads in it.
6. BONUS PART: The ability to automatically make them subscribed automatically after they pay with paypal…I know a way to do this, but it’s not 100% accurate, I would still have to go back and double check if they are actually paid. If you know a slick way to do this I would pay extra.
I look forward to another successful project,
Jay