共有 1 个文件被更改，包括 4 次插入 和 2 次删除
@ -34,7 +34,8 @@ class Site {
|
||||
public function getNextSite ($url) {
|
||||
$query = $this->db->prepare('
|
||||
SELECT * FROM Sites
|
||||
WHERE sorting > (
|
||||
WHERE active = 1
|
||||
AND sorting > (
|
||||
SELECT sorting FROM Sites
|
||||
WHERE url = :url
|
||||
)
|
||||
@ -48,7 +49,8 @@ class Site {
|
||||
public function getPreviousSite ($url) {
|
||||
$query = $this->db->prepare('
|
||||
SELECT * FROM Sites
|
||||
WHERE sorting < (
|
||||
WHERE active = 1
|
||||
AND sorting < (
|
||||
SELECT sorting FROM Sites
|
||||
WHERE url = :url
|
||||
)
|
||||
|
||||
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。