如何使用mysql和php获得下一个3个月的结果 - how to get next 3 month result using mysql and php

how to get next 3 month result using mysql and php

这显示当前月份的结果和

我想要下个3个月的结果我该怎么做请帮我解决这个问题

感谢

代码

  $result = mysql_query("SELECT * FROM register where 
    EXTRACT(YEAR_MONTH FROM `agreementdatee`) =
    EXTRACT(YEAR_MONTH FROM CURRENT_DATE) 
    ORDER BY CAST(flatno as SIGNED INTEGER) 
    DESC LIMIT 4");

完整代码

 <?php
    $username = "root";
    $password = "";
    $hostname = "localhost"; 
    //connection to the database
    $dbhandle = mysql_connect($hostname, $username, $password) 
     or die("Unable to connect to MySQL");
    echo "<br>";
    //select a database to work with
    $selected = mysql_select_db("building",$dbhandle) 
      or die("Could not select examples");

    //execute the SQL query and return records
    $result = mysql_query("SELECT * FROM register where 
    EXTRACT(YEAR_MONTH FROM `agreementdatee`) =
    EXTRACT(YEAR_MONTH FROM CURRENT_DATE) 
    ORDER BY CAST(flatno as SIGNED INTEGER) 
    DESC LIMIT 4");
    //fetch tha data from the database 
    while ($row = mysql_fetch_array($result)) {
       echo "Date: ".$row{'agreementdatee'}."  Name : ".$row{'buildingname'}."  Flat No: ". //display the results
       $row{'flatno'}."<br>";
    }
    //close the connection
    mysql_close($dbhandle);
    ?>

 $result = mysql_query("SELECT * FROM register where 
    agreementdatee BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 3 MONTH)
    ORDER BY CAST(flatno as SIGNED INTEGER) 
    DESC LIMIT 4");

这将选择协议日期>=现在和未来中3个月之前或等于3个月的所有内容