Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- // Sort Action
- // Get VARS ///////////////////////
- $neworder = $_REQUEST['neworder'];
- $myOrder = "";
- if ($_REQUEST['check'] == "1"){
- $myDB = "bb_portfolio";
- } else if ($_REQUEST['check'] == "2"){
- $myDB = "bb_still_life";
- } else if ($_REQUEST['check'] == "3"){
- $myDB = "bb_cgi";
- } else if ($_REQUEST['check'] == "4"){
- $myDB = "bb_location";
- } else if ($_REQUEST['check'] == "5"){
- $myDB = "bb_commercial";
- } else if ($_REQUEST['check'] == "specialsets"){
- $myDB = "bb_specialsets";
- } else if ($_REQUEST['check'] == "contact"){
- $myDB = "bb_contact";
- $myOrder = "normal";
- }
- ///////////////////////////////////////
- include ('includes/connect.inc.php');
- // New Order ////////////////////////
- $neworderSort = array ();
- $neworder = explode(',',$neworder);
- foreach($neworder AS $id){
- $id = str_replace ("item-","",$id);
- array_push ($neworderSort, $id);
- }
- $neworderSortLength = count ($neworderSort);
- if ($myOrder == "normal") {
- for ($i=0;$i<$neworderSortLength;$i++){
- mysqli_query("UPDATE $myDB
- SET sortid = '$i'
- WHERE id = $neworderSort[$i]");
- }
- } else {
- // IN THIS CASE IN REVERSE ORDER !!! //
- for ($i=0;$i<$neworderSortLength;$i++){
- $j = $neworderSortLength - $i;
- mysqli_query("UPDATE $myDB
- SET sortid = '$j'
- WHERE id = $neworderSort[$i]");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement