DATEDIFF and NOW() mysql_fetch_array error


DATEDIFF and NOW() mysql_fetch_array error

我目前正在编写脚本。当用户发布内容且时差小于 5 分钟时,用户无法发布。如果大于 5 分钟,他可以发帖。我建议这段代码可以工作,但我得到一个mysql_fetch_array错误。我的代码有什么问题?

if ($db_found)
 {
 $check="SELECT * DATEDIFF(MINUTE, send_time, CURRENT_TIMESTAMP) FROM bloopp WHERE email = '$email' ORDER BY id DESC LIMIT 1";
 $res = mysql_query($check);
 $data = mysql_fetch_array($res, MYSQLI_NUM);
  if($data[0] < 5)
   {
   echo "You posted not so long ago.<br/>";
   }
  else
   {
   $sql="INSERT INTO bloopp (bloopp, browser, medium, send_time, email) VALUES ('$bloopp', '$browser', 'mobile', NOW(), '$email')";
   $result = mysql_query($sql); 
    if($result)
     {
     header('Location: index.php');
     }
     else
     {
      echo "Something has gone wrong. We’re sorry.";
     }
    }
 }
else
 {
 echo "ERROR";
 }
mysql_close();
?>

你在*之后立即失踪了,

SELECT * DATEDIFF(MINUTE, send_time, CURRENT_TIMESTAMP) 

更改为

SELECT * ,DATEDIFF(MINUTE, send_time, CURRENT_TIMESTAMP) AS `diff` 

查询中创建自定义列时最好提供别名

SELECT  DATEDIFF(MINUTE, send_time, CURRENT_TIMESTAMP) 

删除 *

或者保留它,但在后面添加一个逗号。