How would I make a select query like this...?

[pocobueno1388]

I have 3 rows in the database that I would like to select...but I would like to select them a certain way.

The three rows:
[tt]
-Agility
-Conformation
-Speed
[/tt]

All three of these have integer values.

I would like them all added up in the query and them select the rows in order from greatest to least according to their sum.

agility + conformation + speed

So I was thinking something like this:

mysql_query("SELECT conformation, speed, agility FROM table WHERE conformation + speed + agility > 1 ORDER BY DESC");

But I have no idea if that would even be a valid query...I doubt it.

Any help on how to put this query together would be greatly appreciated ^^

Thank you.

[lilman]

mysql_query("SELECT $column_name FROM $table_name ORDER BY $column_name DESC");

Fill in the variables with your values, and you should be good.

[trq]

Sorry lilman, but did you even read the question?

This works in sqlite.

[code]
SELECT (conformation+speed+agility) AS total FROM tbl ORDER BY total DESC;
[/code]

[pocobueno1388]

Awesome ^^ Thank you very much.