sorting table rows according to one value

[Rmazin]

Hello,

Is there an easy way to sort all rows associated with a query by the value of one of the rows? Sort of like ranking.

for example:

<?php 
$f[1] = 'text 1';
$f[2] = 'text 2';
$f[3] = 'text 3';

$val[1] = '6';
$val[2] = '1';
$val[3] = '25';

?>

I want to display both $f and $val sorted by $val.

Thanks.

[blubb]

A MySQL-query?
=> SELECT ... ORDER BY col
You can order ASC or DESC
See mysql-homepage order-by-optimization

[TeNDoLLA]

Have you tried asort() or arsort() ? This if you sort in php.. else what blubb said.

[Rmazin]

A MySQL-query?
=> SELECT ... ORDER BY col
You can order by ASC or DESC
See mysql-Homepage order-by-optimization

Sorry, i left out the most important part. the value is actually an average of a bunch of results.

The first query looks for distinct results and then the second queries averages for each of those results. I just need to order the averages of all results.

[ardentmirage]

so, you want to display "text 1 appeared 6 times" for example?

[Rmazin]

so, you want to display "text 1 appeared 6 times" for example?

no, i want it to force rank by $val. so i have some text description and a numerical score, i want it to score in order, the problem is the score isnt necessarly raw data it's produced by a math problem after a query.

[crmalibu]

see usort()