php - 没有看到查询结果回显

Question

<?php 
include 'connect.php';
$query = "SELECT * FROM (
SELECT CONCAT(customer_name, ' ', address, ' ', street, ' ', phone_1, ' ', phone_2, ' ', phone_3, ' ', phone_4) as `mysearch`
FROM customers) base
WHERE `mysearch` LIKE '%102%'";

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "customer name: " . $row['customer_name'];    
}
?>

查询正在运行，但我缺少一些能够回显结果的内容。它返回在 phpmyadmin 中运行时的结果。数据库中有 2 个条目需要返回。
我的实际输出如下:

customer name: customer name:

表明它找到了 2 个条目，但我无法让它们回显。 customer_name 与数据库中的字段名称匹配。

Answer 1

如果您希望结果中包含 customer_name，则必须在子查询中将其选择为分隔列:

SELECT 
    * 
    FROM (
        SELECT
            customer_name,
            CONCAT(customer_name, ' ', address, ' ', street, ' ', phone_1, ' ', phone_2, ' ', phone_3, ' ', phone_4) as `mysearch`
        FROM 
            customers
    ) base
WHERE 
    `mysearch` LIKE '%102%'