Sql显示类型=x的10个结果和type= y的10个结果

Question

是否有可能将这两条语句放在一个查询中？

   $q = mysqli_query($con,"SELECT * FROM angebote where (city = '".$_POST['search']."' OR plz = '".$_POST['search']."') AND art = 'biete' ORDER BY id DESC LIMIT 18");

   $p = mysqli_query($con,"SELECT * FROM angebote where (city = '".$_POST['search']."' OR plz = '".$_POST['search']."') AND art = 'suche' ORDER BY id DESC LIMIT 18");

似乎不适用于工会或工会

所以当我试着

    $q = mysqli_query($con,"SELECT * FROM angebote where (city = '".$_POST['search']."' OR plz = '".$_POST['search']."') AND art = 'biete' ORDER BY id DESC LIMIT 10 UNION
                SELECT * FROM angebote where (city = '".$_POST['search']."' OR plz = '".$_POST['search']."') AND art = 'biete' ORDER BY id DESC LIMIT 10");

它说警告: mysqli_fetch_assoc()期望参数1是mysqli_result，布尔值用C：.

Answer 1

UNION在这里工作得很好：

$q = mysqli_query($con, "
    SELECT * FROM 
    (SELECT
      * 
    FROM 
      angebote
    WHERE 
      (city = '".$_POST['search']."' OR plz = '".$_POST['search']."') AND 
      (art = 'biete')
    ORDER BY id DESC LIMIT 10) as biete_tabelle

    UNION

    SELECT * FROM 
    (SELECT
      * 
    FROM 
      angebote
    WHERE 
      (city = '".$_POST['search']."' OR plz = '".$_POST['search']."') AND 
      (art = 'suche')
    ORDER BY id DESC LIMIT 10) as suche_tabelle"
);

这会让你得到你想要的结果。让我们看看这里的例子。

注意:虽然我贴上德语是为了保持一致性，但我想告诉您，最好用英语使用列和变量等名称，所以不讲德语的开发人员更容易阅读您的代码。