If someone can help me figure this out, it would be MUCH appreciated and save me a LOT of time. We publish a daily entertainment publication. Several times a week, we published entertainment giveaways. To enter, users must leave a comment. Users either comment while logged into our site or anonymously.
See here for an example:
http://www.hollywoodchicago.com/news/16990/hollywoodchicagocom-hookup-50...
For years now, I've been clicking on each registered user's name and editing it to get their e-mail address and then editing each anonymous comment to get their e-mail address. We use these e-mail addresses to award prizes to our winners. Is there a script or a way to get these easily in one full swoop from the database?
In the comments table in our database, I see e-mail addresses for anonymous users, so those would be easy to export. But registered users don't have their e-mail addresses in the comments database table. Registered users have their e-mail addresses in the users database table, but I'm not sure how to easily cross reference these without having to go through and look everyone up.
Can anyone help me save time to get a list of all e-mail addresses from registered and anonymous users from one piece of content? Thank you for your time!
HollywoodChicago.com
Comments
Thoughts?
Anyone have any thoughts on this?