query_first($sql); if(!$exists[id]) { $sql = "select id from $bbscolumn where fdParent='$columnid'"; $result = $DB_web->query($sql); $rowsNum = $DB_web->num_rows($result); $columns ="("; for($i=0;$i<$rowsNum-1;$i++) { $rows = $DB_web->fetch_array($result); $columns.= $rows[id].","; } $rows = $DB_web->fetch_array($result); $columns.= $rows[id].")"; } else { $columns = "($columnid)"; } } $sql = "SELECT a.id,a.fdColumnId,a.fdTitle,a.fdHits,a.fdGraph,a.fdCreateDate,a.fdLogin,b.fdName FROM $bbsarticle a,$bbscolumn b where a.fdColumnId=b.id and a.fdWebCool=1"; if($columnid) $sql.=" and a.fdColumnId in $columns "; $sql .= " and ( b.fdIsClose=1 and b.fdIsPublic=1 ) ORDER BY a.fdSetCoolDateTime desc limit 0,$number"; $return_string=""; $result = $DB_web->query($sql); $rows_num=$DB_web->num_Rows($result); if($number>$rows_num) $number=$rows_num; for($i=0;$i<$number;$i++) { $row=$DB_web->fetch_array($result); $return_string.=""; } $return_string.="

	".cutchars(mark($row[fdTitle]),$fd_coolRank)."	".$row[fdCreateDate]."
..更多 ..

"; print "document.write(\"".$return_string."\")"; //else print $return_string; } coolrank(); ?>