• In WordPress I need a listing generated from table wp_usermeta which shows following results per row per user_id :
    user_id, city, first_name+ ” “+lastname

    This is an example of the data in table wp_usermeta.

    126 city Utrecht
    126 last_name Huisman
    126 first_name Fred
    100 city Eibergen
    100 last_name Van der Heide
    100 first_name Toon
    90 city Hengelo
    90 last_name Klaver
    90 first_name Gezien

    What I need is following result:
    126 Utrecht Fred Huisman
    100 Eibergen Toon Van der Heide
    90 Hengelo Gezien Klaver

    Below script is wors. But it gives you an idea of the table _ fields:

    SELECT wp_users.ID, wp_usermeta.meta_key , wp_usermeta.meta_value
    FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
    WHERE
    wp_usermeta.meta_key = "city"
    OR
    wp_usermeta.meta_key = "first_name" + "last_name"
    OR
    (wp_usermeta.meta_key = "lastwill_public" AND wp_usermeta.meta_value = "1")
    AND wp_usermeta.meta_value is null
    ORDER BY wp_users.ID DESC

    Who can help me getting the result.
    In advance thanks!

  • The topic ‘wp_usermeta listing problem’ is closed to new replies.