未返回预期结果的MySQL联合查询，

Question

MySQL查询只返回联合中的第二个选择结果，我不知道why...can您有什么帮助吗？

$query  = "SELECT name ";
$query .= "FROM nutrients ";
$query .= "WHERE name LIKE '%{$sqlsafe_query}%' ";
$query .= "LIMIT 30 ";
$query .= "UNION ALL ";
$query  = "SELECT name ";
$query .= "FROM supplements ";
$query .= "WHERE name LIKE '%{$sqlsafe_query}%' ";
$query .= "LIMIT 30";

Answer 1

$query  = "SELECT name ";

你是不是缺少。之前的=？