Changing display order of db content

1

Hi guys,
Been tinkering about all afternoon with this and i still cant get it to work :frowning:


$newcurrorder = $_POST['newcurrorder'];
$currorder = $_POST['currorder'];
if (isset($newcurrorder)) { 
 $sequenceOKlessthanid = $newcurrorder - 1; 
 $sequenceOKgreaterthanid = $currorder + 1; 
 $resequencedid = $newcurrorder; 
 $sequenceSORTBYcurrorder = "DESC";
 if ($newcurrorder > $currorder) { 
  $sequenceOKlessthanid = $currorder-1; 
  $sequenceOKgreaterthanid = $newcurrorder; 
  $resequencedid -= 1; 
  $sequenceSORTBYcurrorder = "ASC"; 
 
 } 
 $query = "SELECT * FROM models WHERE currorder > $sequenceOKlessthanid AND currorder < $sequenceOKgreaterthanid ORDER BY currorder $sequenceSORTBYcurrorder"; 
 $result = mysql_query ($query) or die ("<p><b>ERROR!!!</b></p><BR>".$query."<BR>"); 
 $j=0; 
 while ($rows = mysql_fetch_object($result)) { 
  $contentid = $rows->model_id; 
  $updateset = $resequencedid; 
  if ($j!= 0) {  
   $currorder = ($rows->currorder)+1; 
   if ($sequenceSORTBYcurrorder == "ASC") {
    $currorder-=2; 
    $updateset = $currorder; 
   }   
   $updatequery = "UPDATE models SET currorder='$updateset' WHERE model_id='$contentid'"; 
   $updateresult = mysql_query ($updatequery) or die ("<p><b>ERROR!!!</b></p><BR>".$updatequery."<BR>"); 
   $j+=1; 
  } 
 }
}

Can anyone see if i am missing anything obviuos.
All i know is that the db is no updated with the new order.
i feel i am over looking somehing blindingly obviuos.
Thanks
Paul