* v0idnull aka Alex Dow.
> Background of problem:
>
> I have lists of information that need to be ordered manually.
>
> Example:
>
>
> [tblList]
> ID - TYPE - POS
> 1 - Name - 1
> 2 - Company - 2
> 3 - Website - 3
>
> that would be the actual table structure and its data, displayed on a
> website.
>
> Now if a user decides he wants "Company" to be on top, he would have to
> manually do it, and the end result would be:
> (hope you're in plain ASCII)
>
> [tblList]
> ID - TYPE - POS
> 2 - Company - 1
> 1 - Name - 2
> 3 - Website - 3
>
>
> Now, is there any to automate the reorganization of POS in MySQL or does
> this have to be manually programmed in my backend of choice?
I think you will have to manually program this. As I understand it the
reorganization will require two rows to change, there is AFAIK no way to
make it so that when you change a column in one row, the server will change
a column in a different row automatically. When triggers enters the arena,
once in the future, then we will probably be able to do stuff like this.
--
Roger
