我该如何获得价值2行成一个 [英] How would I get values from 2 rows into one
本文介绍了我该如何获得价值2行成一个的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要从同一阵列中共有2款不同行访问数据
I need to access data from 2 different rows returned in the same array
下面是图片
Here is a picture
我需要访问FIRST_NAME和姓氏
I need to access first_name and last_name
下面是我的脚本
<?php
ini_set('display_errors', 1);
include_once('db.php'); // database class
$dbase['host'] = 'asdf';
$dbase['user'] = 'asdf';
$dbase['pass'] = 'asdf';
$dbase['name'] = 'asdf';
$db = new DB($dbase);
// SELECT `meta_value` FROM `wp_usermeta` WHERE `meta_key`='password'
$result = $db->query("SELECT * FROM `wp_usermeta` WHERE `meta_key`='user_email'");
while ($row = $result->fetch_array()) {
echo $row['meta_value'];
}
?>
在这个问题上的任何帮助将不胜pciated AP $ P $!
Any help on this issue would be appreciated greatly!
推荐答案
试试这个查询。
SELECT
wp1.meta_value AS first_name,
wp2.meta_value AS last_name
FROM
wp_usermeta wp1
INNER JOIN
wp_usermeta wp2
ON ( wp1.user_id = wp2.user_id )
WHERE 1
AND wp1.meta_key = "first_name"
AND wp2.meta_key = "last_name";
GROUP BY wp1.user_id;
这篇关于我该如何获得价值2行成一个的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文