php选择两张表中的数据,php - 从不同的表中选择数据，匹配并计算具有相同值的数字...

编辑： b>我的数据库中有两个表格：files和user_logs。我想打印files中的所有值，并将它们与user_logs中的相似值进行匹配。

user_logs和files中的列是相同的：

+++++++++++++++++++++

+ fileName | fileId +

+++++++++++++++++++++我想要以下输出：

+++++++++++++++++++++++++++++++++

+ fileName | no. of same values +

+++++++++++++++++++++++++++++++++

+ fileNo1 | 3 +

+++++++++++++++++++++++++++++++++

+ fileNo2 | 1 +

+++++++++++++++++++++++++++++++++

+ fileNo3 | 0 +

+++++++++++++++++++++++++++++++++我不明白我研究的是什么。这是我的代码：

$sql = "SELECT user_logs.fileName,count(*) as c FROM user_logs JOIN files ON user_logs.fileId = files.fileId UNION ALL SELECT files.fileName as file from files a group by a.fileId DESC ";

$result = mysqli_query($con,$sql);

while ($row = mysqli_fetch_assoc($result)) {

$num_row = $row['c'];

echo "

";

echo "

".$row['fileName']."";

echo "

".$num_row ." / 2 Schools Clicked";

echo "

";

}