ORDER BY?

[7724]

Hi Guys,

Writing a php script, which looks into a MySQL database.

Now I want the script to look into what data has been saved into my game table and output the data by positions in order iw goalkeeper 1st, defender 2nd, midfield 3rd. I thought it would be like this but it does not work - any idea thanks?

$Query = "SELECT * from $TableName ORDER by (game.profile = 'Goalkeeper', game.profile = 'defender', game.profile = 'Midfield',)";

 

[ArkM]

1. It seems it's not PHP question, see SQL:
WHERE ... = ...
but
ORDER BY field_name_list
2. SELECT * from php_var then game.field_name = ... - eh?..