ERROR please help

[ferlicia]

$user = $_POST['user'];

 

$result_1= mysqli_query($link, "SELECT * FROM criteria ORDER BY gpa ASC"); --> for the gpa, i wanted to put in the $user but there will be an error

 

                $array = Array();

                $team1 = Array();

 

while($info = mysqli_fetch_array($result_1)){

                    //  echo $info[1];                           

                      array_push($array, $info[1]);          --> $info[1], i wanted to put in the $user also, but there will also be an error.

                  }

 

 

 

 

[abdfahim]

$user must contain a valid field name

 

$result_1= mysql_query("SELECT * FROM `criteria` ORDER BY `".$user."` ASC");

[Muddy_Funster]

That makes no sense - if $user is a value, and not a field name - also, there is absoloutly no need for backticks in that query.