Announcement

Collapse
No announcement yet.

How do I run this query ?

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

  • Jake Bunce
    replied
    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.

    Leave a comment:


  • Punchak
    started a topic How do I run this query ?

    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 !
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X