SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Aug 2013
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Need Help With Getting Values from a Wordpress Database Table

    Hi. I'm trying to list email values of users that have a certain common database value.

    I have a wordpress membership site. On the registration form I've added a field called "Group Name". In the "wp_usermeta" database table in the "meta_value" column it's called "group_name". In the "meta_key" column the value would be something like "Group A" which would be entered by the person registering.

    So I want to list all user emails that have registered as "Group A".

    I've played with the SELECT * FROM wp_usermeta WHERE meta_value='Group A' but I don't know how to get and list the email addresses which are in the same "user_meta" table but under a row called "user_email"

    Can someone help me please?

    Thanks

  2. #2
    SitePoint Member
    Join Date
    Aug 2013
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry - It should read -

    I have a wordpress membership site. On the registration form I've added a field called "Group Name". In the "wp_usermeta" database table in the "meta_key" column it's called "group_name". In the "meta_value" column the value would be something like "Group A" which would be entered by the person registering.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •