關於where like

$s="%".addcslashes($uid, '%_')."%";return DB::fetch_all('select * from %t where uid like %s limit %d,%d',array($this->_table,$s,$start,$perpage));

上面的一段代碼 可以查詢出 關於UID是某位元字的使用者全部資訊

請問下 在這段代碼裡加點什麼 可以是調用出來的資訊 按資訊ID的從大到小“desc”排序？

回複討論(解決方案)

$s="%".addcslashes($uid, '%_')."%";
return DB::fetch_all('select * from %t where uid like %s order by id desc limit %d,%d',array($this->_table,$s,$start,$perpage));

order by id desc

$s="%".addcslashes($uid, '%_')."%";
return DB::fetch_all('select * from %t where uid like %s order by id desc limit %d,%d',array($this->_table,$s,$start,$perpage));

你的回答是正確的。感謝。

我還想追問下 在這段代碼裡 怎麼添加排除文法? 比如uid >1

$s="%".addcslashes($uid, '%_')."%";
return DB::fetch_all('select * from %t where uid like %s and uid>1 order by id desc limit %d,%d',array($this->_table,$s,$start,$perpage));

$s="%".addcslashes($uid, '%_')."%";
return DB::fetch_all('select * from %t where uid like %s and uid>1 order by id desc limit %d,%d',array($this->_table,$s,$start,$perpage));

最後個問題 還是關於這個的

怎麼在這段代碼裡 添加多運算的排除文法?
比如 發布日期變數為 time 有效期間變數為day 目前時間變數為STAMP
怎麼排除time+86400*day > STAMP 把這個運算加入裡面？

$s="%".addcslashes($uid, '%_')."%";
return DB::fetch_all('select * from %t where uid like %s and uid>1 and time+86400*day>STAMP order by id desc limit %d,%d',array($this->_table,$s,$start,$perpage));

$s="%".addcslashes($uid, '%_')."%";
return DB::fetch_all('select * from %t where uid like %s and uid>1 and time+86400*day>STAMP order by id desc limit %d,%d',array($this->_table,$s,$start,$perpage));

但是STAMP 是目前時間戳的時間 資料庫中並未錄入 不能成立啊。。

