I'm trying to update a table to set the sorting order of items and get my
head around some fancier SQL ( I'ld love to get the hang of it). But it's to
no avail so far.
The CMS admin of the site I'm working on should be able to move items
displayed on a webpage up or down for visitors to see on the live page.
Consider the following if you will:
The table I'm working with is the following:
CREATE TABLE `item` (
`id` int(10) unsigned NOT NULL auto_increment,
`pageId` int(10) unsigned default NULL,
`sortId` int(10) ...