SQL ORDER BY
ORDER BY 语句用于根据指定的列对结果集进行排序。ORDER BY 语句默认按照升序对记录进行排序:
$sql = $zbp->db->sql->get()->select($zbp->table['Post']) ->orderBy(array('log_PostTime' => 'desc'), array('log_ID' => 'asc')) ->sql;
SELECT * FROM zbp_post ORDER BY log_PostTime DESC, log_ID ASC