Hi,
I'm having a hard time setting up a promo / referral site.
1. An existing / logged in user sends an email to 5 friends.
2. The Referrer's ID gets passed along when the friend(s) sign in.
3. The Referrer wins prizes based on how many new people they bring in.
4. Those new people are automatically added to Referrer status.
5. The Referrer is automatically updated when he/she hits 5, 10, 15, etc...new users added.
My co-worker says it's easy to do with SQL. I'm not seeing it, yet.
Any and all help is greatly appreciated.
Thanks,
David
I'm having a hard time setting up a promo / referral site.
1. An existing / logged in user sends an email to 5 friends.
2. The Referrer's ID gets passed along when the friend(s) sign in.
3. The Referrer wins prizes based on how many new people they bring in.
4. Those new people are automatically added to Referrer status.
5. The Referrer is automatically updated when he/she hits 5, 10, 15, etc...new users added.
My co-worker says it's easy to do with SQL. I'm not seeing it, yet.
Any and all help is greatly appreciated.
Thanks,
David