Home >Backend Development >PHP Tutorial >数据库 - php先按year倒序查询 再按term为2的先查询 为1的后查询
数据库 - php先按year倒序查询 再按term为2的先查询 为1的后查询
- WBOYOriginal
- 2016-06-06 20:40:241092browse
<code>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
)
</code>
如上面 先在year倒序查询的情况下 再按term为2的先查询 为1的后查询 最好用thinkphp
应该查出来是这样的
<code>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
)
</code>
回复内容：
<code>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
)
</code>
如上面 先在year倒序查询的情况下 再按term为2的先查询 为1的后查询 最好用thinkphp
应该查出来是这样的
<code>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
)
</code>
ORDER关键字是可以给多个字段的
<code>ORDER BY `year` DESC, `term` DESC </code>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：define()和defined()函数有什么区别Next article：为什么这个投票系统在第六行不能获取’keb‘的值