ZBlog ORDER BY

摘要:SQL ORDER BYORDER BY 语句用于根据指定的列对结果集进行排序。ORDER BY 语句默认按照升序对记录进行排序:$sql = $zbp->db->sql->get()->select($zbp->table['Post'

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