PHP Sorting algorithm

Function Description:

Implement the sort function by clicking the [up] [down] button on the data

Data:

Data Id:id

Sort field: rank_id

if($rankNum>0){        //echo $id;   Brand_rank//echo $rankNum; Move to position//reverse lookup before $ranknum elements        $rankNum++; $query= "SELECT ID, brand_rank from ' #@__archives ' WHERE ' Brand_rank ' <={$id} and ' typeID ' =28 and ' Arcrank ' >-1 ORDER by ' Brand_rank ' DESC limit {$rankNum}"; }Else if($rankNum< 0){        //echo $id;        Echo $rankNum; Reverse lookup after ABS ($rankNum) elements        $rankNum=ABS($rankNum); $rankNum++; $query= "SELECT ID, brand_rank from ' #@__archives ' WHERE ' Brand_rank ' >={$id} and ' typeID ' =28 and ' Arcrank ' >-1 ORDER by ' Brand_rank ' ASC limit {$rankNum};"; }    $dsql->setquery ($query); $dsql-Execute ();  while($row=$dsql-GetArray ()) {        $array _id[]=$row["id"]; $rank _id[] =$row["Brand_rank"]; }    $count _num=Count($array _id); $array[' data '] =Array(); $j= 0;  for($i= 1;$i<$count _num;$i++,$j++){        $query= "UPDATE ' #@__archives ' SET ' Brand_rank ' ={$rank _id[$j]} WHERE ' id ' ={$array _id[$i]}"; if(!$dsql->executenonequery ($query)){            $array[' msg '] = "adjustment failed, please refresh retry!" "; $array[' status '] = 2; EchoJson_encode ($array); Exit(); }    }    $query= "UPDATE ' #@__archives ' SET ' Brand_rank ' ={$rank _id[$j]} WHERE ' id ' ={$array _id[0]} "; if(!$dsql->executenonequery ($query)){        $array[' msg '] = "adjustment failed, please refresh retry!" "; $array[' status '] = 1; EchoJson_encode ($array); Exit(); }    $array[' msg '] = ' adjustment successful '; $array[' status '] = 0; EchoJson_encode ($array);

PHP Sorting algorithm