因为我可以将查询结果排序到我的sql数据库

我需要你的帮助

我尝试了几种方法，但我得到错误

排序要求如下:率DESC年龄ASC高度DESC体重ASC

还希望按字段

排序如果你能用一个例子来解释

将是完美的注意到如何和在哪里的顺序是

                   <? Php
                   $ O ='';
                   / / Put the appropriate information:
                   $ Data = array ('localhost', 'user', 'password');
                   $ Con = mysql_connect ($ data [0], $ data [1], $ data [2]);
                   if ($ con) {
                   $ O = 'Error: Could not connect to server. '. mysql_error ();
                   echo $ o;
                   exit;
                   }
                   / / Change the name of the database for yours
                   $ Db_name = 'database';
                   if (mysql_select_db ($ db_name, $ con)) {
                   $ O = 'Error: Could not select database "'. $ Db_name. '". '.                        mysql_error ();
                   echo $ o;
                   exit;
                   }
                   $ Table = 'users' / / Change this only if you know what it does.
                   $ Query = "SELECT * FROM $ table";
                   $ Where = "WHERE";
                   $ And = 0;

                   if (isset ($ _GET ['name']) &&! empty ($ _GET ['name'])) {
                   $ Where. = "Name LIKE '% $ _GET [name]%'";
                   $ And = 1;
                   }
                   if (isset ($ _GET ['rate'])) {
                   $ E = explode ('-', $ _GET ['rate']);
                   if (is_numeric ($ e [0]) && is_numeric ($ e [1])) {
                   if ($ and === 1)
                   $ Where. = "AND";

                   $ Where. = "Rate BETWEEN $ e [0] AND $ e [1]";
                   $ And = 1;
                   }
                   }
                   if (isset ($ _GET ['age'])) {
                   $ E = explode ('-', $ _GET ['age']);
                   if (is_numeric ($ e [0]) && is_numeric ($ e [1])) {
                   if ($ and === 1)
                   $ Where. = "AND";

                   $ Where. = "Age BETWEEN $ e [0] AND $ e [1]";
                   $ And = 1;
                   }
                   }
                   if (isset ($ _GET ['Height'])) {
                   $ E = explode ('-', $ _GET ['Height']);
                   if (is_numeric ($ e [0]) && is_numeric ($ e [1])) {
                   if ($ and === 1)
                   $ Where. = "AND";

                   $ Where. = "Height BETWEEN $ e [0] AND $ e [1]";
                   $ And = 1;
                   }
                   }
                   if (isset ($ _GET ['weight'])) {
                   $ E = explode ('-', $ _GET ['weight']);
                   if (is_numeric ($ e [0]) && is_numeric ($ e [1])) {
                   if ($ and === 1)
                   $ Where. = "AND";

                   $ Where. = "Weight BETWEEN $ e [0] AND $ e [1]";
                   $ And = 1;
                   }
                   }
                   if (isset ($ _GET ['City']) &&! empty ($ _GET ['city'])) {
                   if ($ and === 1)
                   $ Where. = "AND";
                   $ Where. = "City = '$ _GET [City]'";
                   $ And = 1;
                   }
                   if (isset ($ _GET ['Eyes']) &&! empty ($ _GET ['Eyes'])) {
                   if ($ and === 1)
                   $ Where. = "AND";
                   $ Where. = "Eyes = '$ _GET [Eyes]'";
                   $ And = 1;
                   }
                   if (isset ($ _GET ['Hair']) &&! empty ($ _GET ['Hair'])) {
                   if ($ and === 1)
                   $ Where. = "AND";
                   $ Where. = "Hair = '$ _GET [Hair]'";
                   $ And = 1;
                   }


                   if (strlen ($ where)> 6)
                   $ Query. = $ Where;
                   $ Result = mysql_query ($ query, $ con);

                   if ($ result) {
                   $ Nrows = mysql_num_rows ($ result);
                   if ($ nrows> 0) {
                   $ O ='';
                   while ($ row = mysql_fetch_assoc ($ result)) {
                   $ O. = "$ Row [image]";
                   }
                   $ O. = "";
                   Else {}
                   $ O = 'There were no results';
                   }
                   Else {}
                   $ O = 'Error: Unable to run the query. '. mysql_error ($ con);
                   }
                   mysql_free_result ($ result);
                   mysql_close ($ con);
                   echo $ o. "";
                   exit;
                   ?>