下面的工作很好: CASE WHEN @SortDirection = 1 AND @SortBy = 1 THEN announce.[Status] END ASC, CASE WHEN @SortDirection = 2 AND @SortBy = 1 THEN announce.[Status] END
MEMBERSONLY"];{// local torrent so add passkey $dict['announce'] = sprintf($site_config["PASSKEYURL2"],$CURUSER["passkey"]);
unset($dict['announce-list']);
$results = $mysqli->query("SELECT ANNOUNCE_NUMBER,ANNOUNCEMENTS,ANNOUNCE_TYPE,POST_DATE FROM home WHEREANNOUNCE_NUMBER NOT LIKE $excludewelcome AND ANNOUNCE_NUMBER NOT LIKE $excludenews ORDER BY ANNOUNCE_NUMBER//output results from datab