PHP选择2个日期之间的数据[关闭]-Java 学习之路

先生，我尝试mysql php中的运算符，但结果或输出是错误的 .

$currentdate = "05-23-2016";

$startdate = "01-01-1001";

$sql="SELECT * FROM `trial` WHERE Schedule BETWEEN '".$startdate."' AND '".$currentdate."' ";
    $result =mysql_query($sql) or die (mysql_error());
    while($row=mysql_fetch_array($result)){

            echo $row['ID']." - ".$row['Msched'].'-'.$row['Dsched'].'-'.$row['Ysched']."" ;

    }

输出1 - 05-18-2016 4 - 04-28-2005 5 - 01-26-2020

3 回答

试试这个：

$sql = "SELECT *FROM table WHERE schedule BETWEEN '".$startdate."' AND '".$enddate."'";

回复于 2024-05-15T11:09:11+08:00

试试：

$sql="SELECT * FROM `trial` WHERE (Schedule BETWEEN '".$startdate."' AND '".$currentdate."') ";

回复于 2024-05-15T11:09:11+08:00

你也可以尝试：

$sql="SELECT * FROM `trial` WHERE (Schedule >= '".$startdate."' 
  AND Schedule < '".$currentdate."') ";

回复于 2024-05-15T11:09:11+08:00

PHP选择2个日期之间的数据[关闭]

3 回答

相关问题