PHP - 根据数字对 mysql_fetch_array 进行排序

Question

所以我有一个包含 10 行的表格，

它们看起来像这样:

+++++++++++++++++++++++++++++++++++++++
+ ID + ACTIVE + NAME + DESCRIPTION    +
+++++++++++++++++++++++++++++++++++++++
+ 1  + 1      + ONE  + O-N-E          +
+++++++++++++++++++++++++++++++++++++++
+ 2  + 2      + TWO  + T-W-O          +
+++++++++++++++++++++++++++++++++++++++
+ 3  + 0      + THREE+ T-H-R-E-E      +
+++++++++++++++++++++++++++++++++++++++
+ 4  + 4      + FOUR + F-O-U-R        +
+++++++++++++++++++++++++++++++++++++++
+ 5  + 5      + FIVE + F-I-V-E        +
+++++++++++++++++++++++++++++++++++++++
+ 6  + 3      + SIX  + S-I-X          +
+++++++++++++++++++++++++++++++++++++++

我正在通过使用获取此表的值

$result = mysql_query("SELECT * FROM Table WHERE ACTIVE != 0") or die (mysql_error());

然后我用 :

获取它们

$values = mysql_fetch_array($result) or die (mysql_error());

但现在的问题是，结果是这样的:1个2个4个5个3

我想在保留属于 ACTIVE 的 NAME 和 DESCRIPTION 的同时订购它。

我已经阅读了一些关于对 2D 数组进行排序的内容，但我一无所获，所以如果有人有明确的解决方案或清晰的文章，那将对我有很大帮助!感谢阅读。

Answer 1

是的，切换到 mysqli 或其他，但您的问题的答案是:将 ORDER BY ID 添加到您的查询中:

"SELECT * FROM Table WHERE ACTIVE != 0 ORDER BY ID"