php - 打印联合选择

Question

我有以下查询:

$query = mysql_query("  ( SELECT naam 
                          FROM users_social 
                          WHERE user_id = 1 )
                        UNION 
                        ( SELECT COUNT(DISTINCT DATE(datetime)) as days 
                          FROM users_social_invoer 
                          WHERE user_id = 1 )"
                    );

现在我可以使用以下回显来回显查询的第一部分(“naam”):

echo mysql_fetch_row($row_query[0]);

然而，回显 $row_query[1] 并没有像我希望的那样打印出查询的第二部分(联合选择)。我如何实际打印出查询的那一部分？谢谢

Answer 1

你需要 JOIN 而不是 UNION

SELECT us.naam, count(DISTINCT DATE(usi.datetime)) as days
FROM users_social as us
JOIN users_social_invoer as usi
  ON us.user_id = usi.user_id
WHERE us.user_id = 1    
GROUP BY us.naam