Are there best practices for structuring and organizing database tables to facilitate the sorting and swapping of menu items in PHP?

When structuring and organizing database tables for menu items in PHP, it is important to have a table that stores the menu items along with their attributes such as name, price, category, etc. One common approach is to have a 'menu_items' table with columns for id, name, price, category, and any other relevant information. To facilitate sorting and swapping of menu items, you can add a 'position' column to the table which specifies the order in which the items should be displayed. You can then use SQL queries to easily sort and swap menu items based on their position.

// Example SQL query to retrieve menu items sorted by position
$sql = "SELECT * FROM menu_items ORDER BY position ASC";
$result = mysqli_query($conn, $sql);

// Example SQL query to swap positions of two menu items
$sql = "UPDATE menu_items SET position = CASE
            WHEN id = 1 THEN 2
            WHEN id = 2 THEN 1
            ELSE position
        END";
mysqli_query($conn, $sql);