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?
Thanks in advance,
Alex Dow.