wp_usermeta listing problem
-
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+ ” “+lastnameThis 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 GezienWhat I need is following result:
126 Utrecht Fred Huisman
100 Eibergen Toon Van der Heide
90 Hengelo Gezien KlaverBelow 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.