php - 从当前日期开始的表格

Question

$sqlStr = "SELECT name, datescheduled 
             FROM table 
            WHERE datescheduled > NOW() 
         ORDER BY datescheduled DESC";      

我想用一个表格来反射(reflect)上面的结果。我希望接下来 90 天的每一天都有一行，无论 MySQL 表是否有当天的条目。我怎样才能做到这一点？

Answer 1

添加:

$query1 = mysql_query($sqlStr);

    echo "<table><tr>";
    echo "<th>Name</th><th>Date Scheduled</th>";
        while ($rows = mysql_fetch_assoc($query1)) {
            echo "<td>" .$rows['name']. "</td>";
            echo "<td>" .$rows['datescheduled']. "</td>";
            }
        echo "</tr><table>";