Kryptronic Software Support Forum

<?php

//---This simple script re-orders the category displays alphabetically---
//-------

$servername = "localhost";
$username = "databaseuser";
$password = "databasepassword";
$dbname = "databaseuser";

// ----Create connection----
$conn = new mysqli($servername, $username, $password, $dbname);

// --- Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully <br /> <br />";


//--- Get Category IDs and names  -  data ordered alphabetically by name
$sql = "SELECT id, name FROM ecom_cat ORDER BY name";
$result = $conn->query($sql);


//--- initialize counter
$tempvarcounter = 0;



if ($result->num_rows > 0) {
    
    while($row = $result->fetch_assoc()) {
    
         $tempvarcounter = $tempvarcounter + 10;
         $sql = "UPDATE ecom_cat SET sortorder=".$tempvarcounter.", manussortorder=".$tempvarcounter.", xsortorder=".$tempvarcounter.", addlsortorder=".$tempvarcounter." WHERE id='".$row["id"]."'";
         
         echo $sql . "<br />";
         echo $conn->query($sql) ."<br />";
    }
} else {
    echo "0 results";
}



$conn->close();
?>