php - 时间戳比较 MySQL PHP

Question

我正在尝试将行与当前日期和时间进行比较，

    $curDate = date("Y-m-d H").':00:00';
    $query = "SELECT Id FROM Programacao WHERE Data1 = $curDate OR Data2 = $curDate OR Data3 = $curDate 
    OR Data4 = $curDate OR Data5 = $curDate OR Data6 = $curDate  OR Data7 = $curDate";

    $result = mysql_query($query);   
    if(!$result) {echo 'No program today';}
    while ($row = mysql_fetch_array($result))
    {
        echo $row['Id'];
    }

数据库中的行数据是这样的:“2011-09-10 18:00:00”但我总是得到:警告:mysql_fetch_array():提供的参数不是有效的 MySQL 结果有更正吗？

Answer 1

您需要在 SQL 中对日期文字加上引号:

"... WHERE Data1 = '$curDat' ..."

生成的 SQL 应如下所示:

... WHERE Data1 = '2010-12-17 15:00:00' ...