switch order of two records in a table

When in need to change the order of a list use a field to store the order as an int:
Change the order of the records by switching the order value between consecutive elements.

<pre lang="php">
<?php 
switch ($action){
  case 'orderdown':
  case 'orderup':{ 
    //get all list and retain two elements: if moveup operation then I keep prev and current  
    //otherwise I keep current and next
    $rec_list = $this->getChildren($record->id_parent);//all records on this level
    $switch = array();
    for($i = 0; $i < count($rec_list) ; $i++){
      if($rec_list[$i]['id'] == $record['id']){
        if('orderup' == $what && $i != 0){    //not first
          $switch[$rec_list[$i-1]['id']] = $rec_list[$i]['corder'];
          $switch[$rec_list[$i]['id']] = $rec_list[$i-1]['corder'];
          break;
        }elseif('orderdown' == $what && $i != (count($rec_list)-1)){    //not last
          $switch[$rec_list[$i+1]['id']] = $rec_list[$i]['corder'];
          $switch[$rec_list[$i]['id']] = $rec_list[$i+1]['corder'];
          break;
        }
      }
    }

    //valid elements found. Switch them
    if(count($switch) > 0){
      foreach ($switch as $id=>$corder) {
        $sql = "UPDATE page SET corder=$corder WHERE$id";
        $result = mysql_query($sql) or die("SQL ERROR " . mysql_error() . " [$sql] on " . __FILE__ . " at line " . __LINE__);
      }
    }
  }break;
}
?>
</pre>

Centered popup window

<pre lang="javascript">
<SCRIPT TYPE="text/javascript">
<!--
function popUp(theURL, myWidth, myHeight) {
  var winName = 'feedback';
  var features='toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0';
  //var myWidth = 290;
  //var myHeight = 360;
  var isCenter = 'true'; 
  if(window.screen)
    if(isCenter && isCenter=="true"){   
      var myLeft = (screen.width-myWidth)/2;   
      var myTop = (screen.height-myHeight)/2;   
      features+=(features!='')?',':'';   
      features+=',left='+myLeft+',top='+myTop; 
    } 
  var handle = window.open(theURL,winName,features+((features!='')?',':'')+'width='+myWidth+',height='+myHeight);
  handle.opener = window;  handle.focus(); return handle;
}
//--></SCRIPT>
</pre>

Contact us

%%wpcontactform%%

Payment Options

Payment Options:

Pay for 1 Article $10
[paybutton]1 Article post|1|10|||[/paybutton]

adnetworks

Comming soon

TAI : PHP – Think About It

Welcome to Tai : PHP – Think About It

PHP Resources