Hey there,

I got a question about how to select. My mysql database table has 3 different names in it and looks like this

id (int 11)
firstname (varchar 100)
username (varchar 100)
additional name (varchar 100)
display name (char 1)

now the user can select which name he/she want to show on the site. And that is saved in the display name which is a char --> f for firstname, u for username, a for additional name.

Now i want to select the name the user selected from the table ordered by that name as well, but how i do that?

select [selected_name] from members order by [selected_name] i am kinda lost..

greetings Martin

Point 1. You should NOT have spaces in a column name.

use a CASE statement as in (http://www.webmaster-talk.com/the-da...tml#post466198 )

Just use the column name in place of the text shown in the above example.