数组排序问题 [英] Array sorting question
问题描述
你好,
我有mysql表:
+ ---- + --------- +
| 1 | value1 |
+ ---- + --------- +
| 2 | value2 |
+ ---- + --------- +
| 3 | value3 |
+ ---- + --------- +
| 4 | value4 |
+ ---- + --------- +
对结果进行排序的最佳方法是:
$ query = mysql_query(" SELECT * FROM table");
如下所示:
数组(
1 =>''value1'',
2 =>''value2'',
3 =>''value3'',
4 =>''value4''));
TNX
query = mysql_query(" SELECT * FROM table");
如下所示:
>
数组(
1 =>''value1'',
2 =>''value2'',
3 =>''value3'',
4 =>''value4''));
TNX
>从以下结果排序结果的最佳方法是什么:
query = mysql_query(" SELECT * FROM table");
到这样的数组中:
在SELECT语句中添加ORDER BY子句。你没有说明你的列名是什么
,但它看起来像这样:
SELECT * FROM table ORDER BY第2栏
Hello,
I have mysql table:
+----+---------+
| 1 | value1 |
+----+---------+
| 2 | value2 |
+----+---------+
| 3 | value3 |
+----+---------+
| 4 | value4 |
+----+---------+
What is the best way to sort results from:
$query = mysql_query("SELECT * FROM table");
into array like this:
array(
1 => ''value1'',
2 => ''value2'',
3 => ''value3'',
4 => ''value4''));
TNX
query = mysql_query("SELECT * FROM table");
into array like this:
array(
1 => ''value1'',
2 => ''value2'',
3 => ''value3'',
4 => ''value4''));
TNX
> What is the best way to sort results from:
query = mysql_query("SELECT * FROM table");
into array like this:
Add an ORDER BY clause to your SELECT statement. You didn''t say what
the names of your columns are, but it''ll look something like this:
SELECT * FROM table ORDER BY column2
这篇关于数组排序问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!