No Data in MySQL

  • Resolved hossmann

    (@hossmann)


    6 years, 1 month ago

    Hi,

    we are using different attributes next_ad_int_mobile for example.
    We following the Documentation to sync the datas to our database, but inside the wp_users ar nothing from NEXT, only the standard attributes. Can anybody help where the data nect_ad_int_mobile for example is stored?

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hello @hossmann,

    the attributes for the users are stored within the wp_usermeta table. The meta_key values of NADI attributes within the wp_usermeta table are prefixed with “next_ad_int”.

    Best regards,
    medan123

    Thread Starter hossmann

    (@hossmann)

    Hi medan123,

    thank you very much, got it.
    Is it possible to compine a sql query from wp_users and wp_usermeta to get username and mobile number for example?

    Plugin Author schakko

    (@schakko)

    @hossmann
    Sure, you can join the table wp_usermeta on wp_users like
    SELECT u.user_login, um.meta_value FROM wp_users u LEFT JOIN wp_user_meta um ON um.user_id = wp_users.ID WHERE um.meta_key = ‘next_ad_int_${YOUR_PHONE_NUMBER_KEY}’

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘No Data in MySQL’ is closed to new replies.