php all,PHP运行Union All SQL语句

我试图将两个表组合在一起,但是每当我运行该程序时,就会发生这种情况.

如您所见,我已经回显了sql语句.这是我的代码.

$queryc1 = "select sum(repeater),sum(membersigned) from sales UNION ALL select count(*) from approach;"; //DO INNERJOIN PRACTISE

$resultc1 = mysqli_query($dbconn,$queryc1);

echo "

Repeater	Members	Approach

while($row = mysqli_fetch_array($resultc1)) {

echo "

";

echo "

" . $row['sum(repeater)'] . "";

echo "

" . $row['sum(membersigned)'] . "";

echo "

" . $row['count(*)'] . "";

echo "

";

}

echo "

";

echo $queryc1;

我想在照片中显示count(*),作为已生成表格的第三列.

解决方法:

您不需要在此处选择UNION,而是可以使用子查询：

select sum(repeater) as repeater_sum,

sum(membersigned) as membersigned_sum,

(select count(*) from approach) as approach_count

from sales;

并在PHP中使用$row [‘repeater_sum’] ..等等

标签：phpmyadmin,mysql,php

来源： https://codeday.me/bug/20191026/1940423.html