请帮我解释一下一个PHPmySql语句,在线等
语句是这样的:SELECT t.*, f.name FROM {$tablepre}threads t, {$tablepre}forums f WHERE t.fid<>'$fid' AND f.fid=t.fid AND t.digest in (1,2,3) ORDER BY t.dateline DESC LIMIT 0, 12
我看不懂 {$tablepre} ,{$tablepre},高手帮我分析一下
语句是这样的:SELECT t.*, f.name FROM {$tablepre}threads t, {$tablepre}forums f WHERE t.fid<>'$fid' AND f.fid=t.fid AND t.digest in (1,2,3) ORDER BY t.dateline DESC LIMIT 0, 12
我看不懂 {$tablepre} ,{$tablepre},高手帮我分析一下
要么是表 要么是视图 要么是个带括号的查询语句
看你前面那窜他应该是个表或者是视图
不会是个带括号的查询语句
$tablepre = 'cdb_';
下边
"SELECT t.*, f.name FROM {$tablepre}threads t, {$tablepre}forums f WHERE t.fid <>'$fid' AND f.fid=t.fid AND t.digest in (1,2,3) ORDER BY t.dateline DESC LIMIT 0, 12"
就变成
"SELECT t.*, f.name FROM cdb_threads t, cdb_forums f WHERE t.fid <>'$fid' AND f.fid=t.fid AND t.digest in (1,2,3) ORDER BY t.dateline DESC LIMIT 0, 12"
$fid 是版块id
查找版块id为$fid之外的精华主题,12条
{$tablepre}是表前缀如 cdb_ discuz安装时会要求指定表前缀