比如说,现在有如下两句查询语句:$all = DB::fetch_first("SELECT * FROM ".DB::table('common')." WHERE status=2 ORDER BY dateline DESC");
$all2 = DB::query("SELECT * FROM ".DB::table('common')." WHERE status=2 ORDER BY dateline DESC");
怎么合并为一句查询语句呀?得有相同的查询结果哦。希望各位大侠帮帮忙。
$all2 = DB::query("SELECT * FROM ".DB::table('common')." WHERE status=2 ORDER BY dateline DESC");
不就已经包括第一条了
$all = DB::query("SELECT * FROM ".DB::table('common')." WHERE status=2 ORDER BY dateline DESC");
$result = array();
while ($row = DB::fetch($all)) {
$result[] = $row;
}
//$result[0] == DB::fetch_first(...)
$all2 = DB::query("SELECT * FROM ".DB::table('common')." WHERE status=2 ORDER BY dateline DESC limit 0,1");