thinkphp - php先按year倒序查询再按term为2的先查询为1的后查询-PHP中文网问答

文章专题 AI工具学习下载问答源码最近更新

PHP

会员中心讲师中心微信公众号

thinkphp - php先按year倒序查询再按term为2的先查询为1的后查询

巴扎黑 2017-04-10 15:10:56

[PHP讨论组]

481

Array
(
    [id] => 1
    [user_id] => 1
    [year] => 2013-2014
    [term] => 1

)
Array
(
    [id] => 2
    [user_id] => 1
    [year] => 2013-2014
    [term] => 2

)
Array
(
    [id] => 3
    [user_id] => 1
    [year] => 2012-2013
    [term] => 1

)

如上面先在year倒序查询的情况下再按term为2的先查询为1的后查询最好用thinkphp
应该查出来是这样的

Array
(
    [id] => 2
    [user_id] => 1
    [year] => 2013-2014
    [term] => 2

)
Array
(
    [id] => 1
    [user_id] => 1
    [year] => 2013-2014
    [term] => 1

)
Array
(
    [id] => 3
    [user_id] => 1
    [year] => 2012-2013
    [term] => 1

)