//获取当前的时间,格式如20081014 $today = date("Ymd", $time); $yesterday = date("Ymd", $time - 3600); SELECT count( * ) as c1, FROM_UNIXTIME( dateline, '%Y%m%d' ) as time FROM {$tablepre}threads t, {$tablepre}forums WHERE t.fid <>'$fid' AND f.fid=t.fid AND f.fid not in (0) AND t.displayorder not in (-1,-2) FROM_UNIXTIME( time, '%Y%m%d' ) IN ('$today', '$yesterday') GROUP BY FROM_UNIXTIME( dateline, '%Y%m%d' )
SELECT COUNT(*) AS c1, FROM_UNIXTIME( t.dateline, '%Y%m%d' ) AS time FROM {$tablepre}threads t, {$tablepre}forums WHERE t.fid <>'$fid' AND f.fid=t.fid AND f.fid not in (0) AND t.displayorder not in (-1,-2) AND FROM_UNIXTIME( t.dateline, '%Y%m%d' ) IN ('$today', '$yesterday') GROUP BY FROM_UNIXTIME( t.dateline, '%Y%m%d' )
出错啊 SQL: SELECT COUNT(*) AS c1, FROM_UNIXTIME( t.dateline, '%Y%m%d' ) AS time FROM [Table]threads t, [Table]forums WHERE t.fid <>'0' AND f.fid=t.fid AND f.fid not in (0) AND t.displayorder not in (-1,-2) AND FROM_UNIXTIME( t.dateline, '%Y%m%d' ) IN ('20081015', '20081014') GROUP BY FROM_UNIXTIME( t.dateline, '%Y%m%d' )Error: Unknown column 'f.fid' in 'where clause' Errno.: 1054
//获取当前的时间,格式如20081014
$today = date("Ymd", $time);
$yesterday = date("Ymd", $time - 3600);
SELECT count( * ) as c1, FROM_UNIXTIME( dateline, '%Y%m%d' ) as time
FROM {$tablepre}threads t, {$tablepre}forums
WHERE t.fid <>'$fid' AND f.fid=t.fid AND f.fid not in (0) AND t.displayorder not in (-1,-2)
FROM_UNIXTIME( time, '%Y%m%d' ) IN ('$today', '$yesterday')
GROUP BY FROM_UNIXTIME( dateline, '%Y%m%d' )
SELECT COUNT(*) AS c1, FROM_UNIXTIME( t.dateline, '%Y%m%d' ) AS time
FROM {$tablepre}threads t, {$tablepre}forums
WHERE t.fid <>'$fid' AND f.fid=t.fid AND f.fid not in (0) AND t.displayorder not in (-1,-2)
AND FROM_UNIXTIME( t.dateline, '%Y%m%d' ) IN ('$today', '$yesterday')
GROUP BY FROM_UNIXTIME( t.dateline, '%Y%m%d' )
SQL: SELECT COUNT(*) AS c1, FROM_UNIXTIME( t.dateline, '%Y%m%d' ) AS time
FROM [Table]threads t, [Table]forums
WHERE t.fid <>'0' AND f.fid=t.fid AND f.fid not in (0) AND t.displayorder not in (-1,-2)
AND FROM_UNIXTIME( t.dateline, '%Y%m%d' ) IN ('20081015', '20081014')
GROUP BY FROM_UNIXTIME( t.dateline, '%Y%m%d' )Error: Unknown column 'f.fid' in 'where clause'
Errno.: 1054
其实你自己也可以检查一下吗.