php - 显示在底部的查询中的子查询结果

Question

为标题道歉，我想运行这样的查询:

$query = mysql_query("
  select * from taskdetail
  where userid = '" . $rec['id'] . "'
    and comp_status = '0'
    and duedate > '" . date("Y-m-d") . "'
  order by duedate,importantlevel ASC
  LIMIT " . $getnextrecord . " , $limit
");

然后像这样运行一个

$query_noduedate = mysql_query("
  select * from taskdetail
  where userid = '" . $rec['id'] . "'
    and comp_status = '0'
    and duedate = '0000-00-00'
") or die(mysql_error());

我希望第二个查询的结果(没有截止日期的任务)显示在第一个查询结果的下方(几乎就像是第一个查询的结果)。

原因是我有很多额外的功能可以改变您看到的任务数量，例如，如果用户选择查看一个结果并单击下一步，它当前会完成每个任务，我只是想追加第二个查询结果在第一个的末尾，而不是有两组结果。

我可以将查询组合在一起，例如:

$query = mysql_query("
  select * from taskdetail
  where userid='" . $rec['id'] . "'
    and comp_status='0'
    and ( duedate > '" . date("Y-m-d") . "' or duedate = '0000-00-00' )
  order by duedate,importantlevel ASC
  LIMIT " . $getnextrecord . " , $limit");

但是，截止日期为 0000-00-00 的任务将出现在顶部。

不确定最好的解决方案

干杯

Answer 1

您可以尝试使用 while 循环来处理数据行。

 //Your first query
    $query = mysql_query("select * from taskdetail where userid='" . $rec['id'] . "' and comp_status='0'  and  duedate > '" . date("Y-m-d") . "' order by duedate,importantlevel ASC LIMIT  " . $getnextrecord . " , $limit");

    //Now perform what you want with each row of results
    //Cycle through each row of results
    while($row = mysql_fetch_array($query)){
        //assign the result sest to the $row array
        extract($row);

        //Here would go your code to display what you want from the first results which are now stored in the $row array with keys starting at 0

        //Your sub query
        $query = mysql_query("select * from taskdetail where userid='" . $rec['id'] . "' and comp_status='0'  and  ( duedate > '" . date("Y-m-d") . "' or duedate = '0000-00-00' ) order by duedate,importantlevel ASC LIMIT  " . $getnextrecord . " , $limit");

        //Here is where you would display what you want from the second query. If you have multiple results you could duplicate they while loop from above.

$i++;

    }

如果您只想要两个特定的行而不是在可能显示多行的循环内显示结果，您可以将标记为显示结果的部分替换为将具有特定值的结果分配给数组的代码部分或字符串变量，然后在 while 循环之外显示它们。

希望这能给你一个正确的开始方向。