I am trying to retrieve each user's first and last name, phone, email, and address from the usermeta table. I'm having trouble selecting multiple meta_values, each with its own meta_key, using a single sql query.
I would like the data returned as
First Name, Last Name, Phone, Address, Email First Name, Last Name, Phone, Address, Email First Name, Last Name, Phone, Address, Email First Name, Last Name, Phone, Address, Email
I have access to the actual DB via phpMyAdmin, so I would like help with the mySql query.
get_user_meta()
? (Or, more abstractly,get_metadata()
?)