Announcement

Collapse
No announcement yet.

How do I run this query ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I run this query ?

    Hi,

    What is the query to list all members of my forum that are agrea to receive admin emails ? the row 'option' in the user table is a bit complicated for me.
    Basicaly, it should be like this :
    SELECT email FROM user WHERE **** ORDER BY email DESC;
    I'm looking for *** of course

    Thanks for your help !

  • #2
    If you want to build an email list, go here:

    Admin CP -> Users -> Generate Mailing List

    Select the All Usergroups option and make sure Include users that have declined admin emails is set to No.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X