$posts_self_all = $db->result_first("SELECT posts FROM {$tablepre}members WHERE uid='$uid'");
$posts_self_fid = $db->result_first("SELECT count($posts_self_all) FROM {$tablepre}forums WHERE fid='$fid'"); if($posts_self_fid < 100) {
showmessage('you post need 100', dreferer());
} else {
$db->query("INSERT INTO {$tablepre}vip (uid, $fid) VALUES ('$uid', '$fid')");
}我想做的效果是...某会员在本版发言量大于100才可以申请会员成功 , 否则退回现在我只可以做到 某会员的总发言量 , 而不是 某会员在本版发言量...有高手能帮忙修改一下代码不??万分感激.......
$posts_self_fid = $db->result_first("SELECT count($posts_self_all) FROM {$tablepre}forums WHERE fid='$fid'"); if($posts_self_fid < 100) {
showmessage('you post need 100', dreferer());
} else {
$db->query("INSERT INTO {$tablepre}vip (uid, $fid) VALUES ('$uid', '$fid')");
}我想做的效果是...某会员在本版发言量大于100才可以申请会员成功 , 否则退回现在我只可以做到 某会员的总发言量 , 而不是 某会员在本版发言量...有高手能帮忙修改一下代码不??万分感激.......
SELECT COUNT(POSTS) FROM {$TABLEPRE}MEMBERS JOIN {$TABLEPRE}FORUMS ON {$TABLEPRE}MEMBERS.FID = {$TABLEPRE}FORUMS.FID
WHERE {$TABLEPRE}MEMBERS.UID='$UID' AND {$TABLEPRE}FORUMS.FID='$FID'
而fid 是在 {$tablepre}forums这怎办...
SQL: SELECT count(*) FROM [Table]forums WHERE fid='2' AND uid='1'
Error: Unknown column 'uid' in 'where clause'
Errno.: 1054