Topic: How to retrieve column names ordered by value and output the result with echo

[EliteIntegrity]

Hi,

Server version - 5.0.67
the statement - that's what I hope to find out
any errors - na
currently doing not to my liking - na
tried so far - complicated sorting (for a beginner) using PHP want to use query instead.
What I want to achieve -

I want to be able retrieve column names from a single specified row ordered by the numerical value within those columns.

e.g if I have exam results table with a row (history 50, ict 100, art 70) for a student (bill).

 I want the output of the query to be the column names ordered by the value they hold, i.e.

ict art history


Many thanks.

John

[jskywalker]

can you give use the outpuy of:
1) desc table  ( or output of SHOW CREATE TABLE ....)
2) the output of a single row of your data ?

Than, if that is know, the answer should not be hard.
(but i think it will be a PHP answer, and ot a MYSQL answer)

[fenway]

Yeah, you can't do that in mysql.

[EliteIntegrity]

Thanks v-much. PHP was the solution.

Exploring your suggestions led me to discover mysql_field_name($result, x)
And the final solution.

...
$query="SELECT art, ict, history FROM results WHERE name='$name'";
...
$results_array=array(mysql_result($result,0,art),mysql_result($result,0,ict),mysql_result($result,0,history));
$column_names_array=array(mysql_field_name($result, 0),mysql_field_name($result, 1),mysql_field_name($result, 2));

array_multisort($results_array,$column_names_array);

print_r($column_names_array);

Thanks so much again.

John