Question

谁知道php程序中怎么用数据库datediff 实现 提取1个小时之内的新闻。 我使用的是jtbc cms php1.0版

case 'yestoday1':
$tsqlstr = "select * from $tdatabase where " . ii_cfnames($tfpre, 'hidden') .

"=0 and datediff(" . ii_cfnames($tfpre, 'fbshijian') . ",now())=-2 and " . ii_cfnames

($tfpre, 'good') . "=0";
$tsqlorder = " order by $tidfield desc";
break;

如这样我已经实现了提取昨天信息，，按天数提取都可以成功，，就是按时间或分钟提取不成功。

Answer 1

select * from table where datefiff = datefiff - 3600

追问

$tsqlstr = "select * from $tdatabase where " . ii_cfnames($tfpre, 'hidden') .

"=0 and datediff(" . ii_cfnames($tfpre, 'fbshijian') . ",now())=-2 and " . ii_cfnames

那我这段代码具体要怎么改 他这个cms不太一样 有好多都是自定义的东西

我是完全的菜鸟 呵呵 麻烦了 一定给你加分

Answer 2

where datefiff = datefiff - 3600