• Hi,

    I created a form with contact form DB, and in this form there a are a possibility to subscribe in newsletter (check box checked).

    I want to know if there are a possibility to make a SQL query that returns all emails that are registered in newsletetr.

    jockhip12

Viewing 5 replies - 1 through 5 (of 5 total)
  • There is a FAQ on How to Query the DB for your form data

    The short answer is to turn on the option for “Show the query used to display results” which shows the query used in the admin page, then just wrap that in a an outer select to pull the info you want.

    Thread Starter jockhip12

    (@jockhip12)

    Thanks mr Simpson for your reply.

    In fact I want to use subscribe2 plugin that allows to notify users who are registered in the newsletter each new post, but the problem is that the emails must be manually added, so I want to make a sql query that is used to return all users are tick Subscribe to newsletter on the form. So this way the contact list will update dynamically.

    jockhip12

    Thread Starter jockhip12

    (@jockhip12)

    I don’t know if you are understand what I mean, but I need to use SQL query and not to use the short code of Contact form DB plugin in the admin page.

    Thanks again

    jockhip12

    I have pointed you to how to create such a SQL query, no short codes. You should have everything you need.

    Thread Starter jockhip12

    (@jockhip12)

    Oh Yes, sorry Mr Simpson. I have not been careful.
    Thanks for your help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘contact-form-7-to-database-extension’ is closed to new replies.