I would like to create a column in Community by which a registrant can provide the e-mail address of the person who referred him/her to the site (this much I can do).
I would then like to be able to generate a report that tells me how many times each e-mail address appears in that column, so that I can give special access to anyone who referred 5 new registrants. This I don't know how to do.
We're using MySQL, but I don't know enough SQL to be able to generate that kind of report. Automating is good, but getting the counts in a report form is the goal.
Can someone point me in the right direction?
Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com
I would then like to be able to generate a report that tells me how many times each e-mail address appears in that column, so that I can give special access to anyone who referred 5 new registrants. This I don't know how to do.
We're using MySQL, but I don't know enough SQL to be able to generate that kind of report. Automating is good, but getting the counts in a report form is the goal.
Can someone point me in the right direction?
Alan Frayer
Don't just read the news - make the news!
Your World News - http://yourworldnews.frayernet.com